Re: [PERFORM] VACUUM vs. REINDEX

2006-07-08 Thread Steinar H. Gunderson
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. Whi

Re: [PERFORM] VACUUM vs. REINDEX

2006-07-08 Thread Stefan Kaltenbrunner
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