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

From Tom Lane
Subject Re: does VACUUM ANALYZE complete with this error?
Date
Msg-id 19960.1179928866@sss.pgh.pa.us
Whole thread Raw
In response to does VACUUM ANALYZE complete with this error?  (Susan Russo <russo@morgan.harvard.edu>)
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: Susan Russo
Date:
Subject: does VACUUM ANALYZE complete with this error?
Next
From: "Andy"
Date:
Subject: LIKE search and performance