| From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
|---|---|
| To: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: VACUUM vs. REINDEX |
| Date: | 2006-07-08 09:16:46 |
| Message-ID: | 44AF77FE.5040901@kaltenbrunner.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Steinar H. Gunderson wrote:
> On Fri, Jul 07, 2006 at 09:28:52PM -0400, Chris Hoover wrote:
>> You need to increase your fsm settings. The database is telling you it is
>> trying to store 177K+ pages, but you have only provided it with 20K. Since
>> these pages are cheap, I would set your fsm up with at least the following.
>
> While we're at it, is there a good reason why we simply aren't upping the FSM
> defaults? It seems like a lot of people are being bitten by it, and adding
> more pages and relations is as you say cheap...
that is already done in -HEAD at the initdb stage:
...
selecting default shared_buffers/max_fsm_pages ... 4000/200000
...
Stefan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-07-09 14:47:52 | Re: Opteron/FreeBSD/PostgreSQL performance poor |
| Previous Message | Steinar H. Gunderson | 2006-07-08 08:13:16 | Re: VACUUM vs. REINDEX |