Re: tuning our database by increasing shared buffer

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

 



"Allgood, John" <jallgood@xxxxxxx> wrote:
 
> What exactly am I looking for
 
> INFO:  free space map contains 2667 pages in 22 relations
> DETAIL:  A total of 3008 page slots are in use (including overhead).
> 3008 page slots are required to track all free space.
> Current limits are:  153600 page slots, 1000 relations, using 965
kB.
 
This is saying that limits of 3008 and 22 would have (barely) been
sufficient as of the vacuum run.  You want to leave a little room
above that, but if you're consistently getting numbers on this order
of magnitude, you could reduce the fsm settings from 153600 and 1000
and get back a little RAM for additional cache space.
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[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