Search Postgresql Archives

number of page slots needed exceeds max_fsm_pages

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux