Postgres Pro
Downloads
Home   >   mailing lists

number of page slots needed exceeds max_fsm_pages - Mailing list pgsql-general

From David Brain
Subject number of page slots needed exceeds max_fsm_pages
Date
Msg-id 445765A0.9070602@bandwidth.com
Whole thread Raw
Responses Re: number of page slots needed exceeds max_fsm_pages  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Chris Velevitch"
Date:
Subject: Re: How to join to delete
Next
From: "John D. Burger"
Date:
Subject: Re: How would I write this query...