Re: does VACUUM ANALYZE complete with this error?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org, harvsys(at)morgan(dot)harvard(dot)edu
Subject: Re: does VACUUM ANALYZE complete with this error?
Date: 2007-05-23 14:01:06
Message-ID: 19960.1179928866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Susan Russo <russo(at)morgan(dot)harvard(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andy 2007-05-23 15:08:49 LIKE search and performance
Previous Message Susan Russo 2007-05-23 13:26:54 does VACUUM ANALYZE complete with this error?