Francisco Reyes wrote:
Using 8.1.4
Have autovacuum running and it shows on the logs as running.
Ever couple of days in the last week when I tried to run vacuum analyze
postgresql complained that I needed to increase my fsm_pages.
I am going to start scheduling vacuum analyze in crontab.. but if
autovacuum is running shouldn't I not need to be running vacuum
analyze?. and more importantly shouldn't I not be running out of fsm_pages?
In many instances the default thresholds for autovacuum are too
conservative. You can try making it more aggressive and see what
happens, you can do this generally, or on a table specific basis.
