does VACUUM ANALYZE complete with this error?

From: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Cc: harvsys(at)morgan(dot)harvard(dot)edu, russo(at)morgan(dot)harvard(dot)edu
Subject: does VACUUM ANALYZE complete with this error?
Date: 2007-05-23 13:26:54
Message-ID: 200705231326.l4NDQsX0000426@larrys.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hi,

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),
however am wondering if the vacuum analyze which reports the error was
actually completed?

Thanks
Susan Russo

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-05-23 14:01:06 Re: does VACUUM ANALYZE complete with this error?
Previous Message Gregory Stark 2007-05-23 08:31:26 Re: Postgres Benchmark Results