Re: tuning our database by increasing shared buffer - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: tuning our database by increasing shared buffer
Date
Msg-id 4A41F0BD0200002500027EDA@gw.wicourts.gov
Whole thread Raw
In response to Re: tuning our database by increasing shared buffer  ("Allgood, John" <jallgood@ohl.com>)
List pgsql-admin
"Allgood, John" <jallgood@ohl.com> 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

pgsql-admin by date:

Previous
From: "Allgood, John"
Date:
Subject: Re: tuning our database by increasing shared buffer
Next
From: Green Idol
Date:
Subject: himanshu purohit wants you to be a Green Idol.