| From: | Phillip Berry <pberry(at)stellaconcepts(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Maximum reasonable free space map |
| Date: | 2008-12-17 00:55:29 |
| Message-ID: | 200812171155.29697.pberry@stellaconcepts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Everyone,
Just wondering what the maximum reasonable free space map setting should be? I'm receiving the
following advice from vacuum:
INFO: free space map contains 170803 pages in 117 relations
DETAIL: A total of 185000 page slots are in use (including overhead).
733008 page slots are required to track all free space.
Current limits are: 185000 page slots, 5000 relations, using 1623 KB.
NOTICE: number of page slots needed (733008) exceeds max_fsm_pages (185000)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 733008.
I thought 185K was pretty high, is going to 700K+ reasonable? I've got 16GB of ram and am running
very high volume 100GB+ DBs.
Cheers
Phil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | salman | 2008-12-17 01:56:26 | PITR archive_status/%p.done files |
| Previous Message | Tom Lane | 2008-12-17 00:47:14 | Re: TIMESTAMP with a timezone offset |