full vacuum - resources - scaling

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux