What do you have max_fsm_pages set to?
Currently, max_fsm_pages=2
Running VACUUM VERBOSE reports:
NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2)
HINT: Consider increasing the configuration parameter max_fsm_pages to a
value over 237312.
Is this measurement
Nicola Mauri [EMAIL PROTECTED] writes:
What do you have max_fsm_pages set to?
Currently, max_fsm_pages=2
Running VACUUM VERBOSE reports:
NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2)
HINT: Consider increasing the configuration parameter max_fsm_pages
I'm using 8.1.4 on linux.
Autovacuum is enable with these settings:
stats_start_collector = on
stats_row_level = on
autovacuum = on
autovacuum_naptime = 60
autovacuum_vacuum_threshold = 1000
autovacuum_analyze_threshold = 500
Data stored in the database didn't
Nicola Mauri [EMAIL PROTECTED] writes:
Data stored in the database didn't groove very much in the last months
(pg_dump still generates a 4GB compressed file), but data files now
occupies 20 GB on disk.
I know that a vacuum full or a full dump/restore is needed to reclaim
filesystem space.