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)