number of page slots needed exceeds max_fsm_pages

From: David Brain <dbrain(at)bandwidth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: number of page slots needed exceeds max_fsm_pages
Date: 2006-05-02 13:58:56
Message-ID: 445765A0.9070602@bandwidth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a cron job that vacuums one of my dbs daily (Postgres 7.3.11)-
using 'vacuumdb -a -f -z -q -U postgres'. Currently I get an email
containing the folowing error messages:

NOTICE: number of page slots needed (38320) exceeds max_fsm_pages (20000)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 38320.
NOTICE: number of page slots needed (40912) exceeds max_fsm_pages (20000)
...
...

However if I run the command by hand it appears to complete without
error, any thoughts as to why this might be? The max_fsm_pages has been
set to 50000 in postgresql.conf.

Thanks,

David.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2006-05-02 14:15:02 Re: How would I write this query...
Previous Message Chris Velevitch 2006-05-02 13:00:55 Re: How to join to delete