Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Nicola Mauri
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

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Tom Lane
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

[ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-24 Thread Nicola Mauri
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

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-24 Thread Tom Lane
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.