Re: [PERFORM] does VACUUM ANALYZE complete with this error? - Mailing list pgsql-performance

From Tom Lane
Subject Re: [PERFORM] does VACUUM ANALYZE complete with this error?
Date
Msg-id fb0770bacd7f9d592bc7f2b4906d2e68
Whole thread Raw
List pgsql-performance
Susan Russo <russo@morgan.harvard.edu> writes:
> We're seeing these type of error messages:

> NOTICE:  number of page slots needed (237120) exceeds max_fsm_pages (120000)
> HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a value over 237120.
> vacuumdb: vacuuming database "fb_2007_01_17"

> I've played 'catch up' wrt adjusting max_fsm_pages (seems to be a regular event),

What PG version is that?  I recall we fixed a problem recently that
caused the requested max_fsm_pages to increase some more when you'd
increased it to what the message said.

            regards, tom lane


pgsql-performance by date:

Previous
From: Peter Schuller
Date:
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
Next
From: Scott Marlowe
Date:
Subject: Re: does VACUUM ANALYZE complete with this error?