Re: [GENERAL] Wrong number of empty toast pages

2010-06-17 Thread Tom Lane
Jacek Trzmiel writes: > I have a problem with growing toast table in pgsql 8.3.5. Probably > raising max_fsm_pages and running autovacuum more aggresively will fix > it, but during investigation I've got this puzzling output from VACUUM > ANALYZE VERBOSE: >> INFO: "pg_toast_16505": found 7563

[GENERAL] Wrong number of empty toast pages

2010-06-17 Thread Jacek Trzmiel
Hi, I have a problem with growing toast table in pgsql 8.3.5. Probably raising max_fsm_pages and running autovacuum more aggresively will fix it, but during investigation I've got this puzzling output from VACUUM ANALYZE VERBOSE: INFO: "pg_toast_16505": found 756385 removable, 23003704 nonr