Hi,
I have noticed that my full vacuum and re-index script is taking a day and a
half instead of 1/2 day.
Recently, the size of my database cluster has doubled to 130 GB. Would
anyone recommend increasing one or more of these to help get my full vacuums
to run a little faster?
Thanks,
~DjK
work memory 49152 KB
shared buffers 65536 (8 KB)
maxfsmpages 480001 (6 bytes each)
maxfsmrelations 30000 (70 bytes each)
effective cache 983040 (8 KB each)