| 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
| 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 |