Hi Folks, I Routinely vacuum analyze by database four times a day if is non locking vacuum (not full)
Vacuum operation takes 15-20 mins database size is 4 GB. The problem is the databser server becomes bit slower as its' load average remains at 2-4 during vacuum. can anyone tell me if this situation can be made better. i remember there is a vacuum_mem variable in GUC file. Does More memory and faster I/O helps? I currenltly have RAID 1 on 2*36 GB 10 K 80 MB/s HDD 1 GB RAM and PIII 800 Dual Processors m/c. I know the more frequently u vaccum the lesser time it takes. Regds MAllah. ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
