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)



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to