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/