Re: tuning our database by increasing shared buffer

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "John Allgood" <jallgood(at)ohl(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Barbara Stephenson" <barbara(at)turbocorp(dot)com>, "Glyn Astill" <glynastill(at)yahoo(dot)co(dot)uk>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: tuning our database by increasing shared buffer
Date: 2009-06-24 14:24:13
Message-ID: 4A41F0BD0200002500027EDA@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Allgood, John" <jallgood(at)ohl(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Green Idol 2009-06-25 08:28:53 himanshu purohit wants you to be a Green Idol.
Previous Message Allgood, John 2009-06-24 14:03:41 Re: tuning our database by increasing shared buffer