Sooo ... i disabled autovacuum using the following request : INSERT INTO pg_catalog.pg_autovacuum (vacrelid, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age) SELECT oid, 'f', -1, -1, -1, -1, -1, -1, -1, -1 FROM pg_catalog.pg_class WHERE relnamespace = (SELECT OID FROM pg_namespace WHERE nspname = '_ob2replication' ) AND relhasindex;
I waited ~24h then ran a vacuum verbose analyze on some slony table. INFO: "sl_listen": found 0 removable, 1282 nonremovable row versions in 30 pages DETAIL: 0 dead row versions cannot be removed yet. There were 6113 unused item pointers. 27 pages contain useful free space. 0 pages are entirely empty. INFO: "sl_event": found 0 removable, 2599 nonremovable row versions in 7229 pages DETAIL: 0 dead row versions cannot be removed yet. There were 784524 unused item pointers. 7220 pages contain useful free space. 0 pages are entirely empty. INFO: "sl_confirm": found 0 removable, 27585 nonremovable row versions in 321 pages DETAIL: 0 dead row versions cannot be removed yet. There were 65301 unused item pointers. 188 pages contain useful free space. 0 pages are entirely empty. INFO: "sl_log_1": found 32843 removable, 16694 nonremovable row versions in 4464 pages DETAIL: 0 dead row versions cannot be removed yet. There were 151138 unused item pointers. 3648 pages contain useful free space. 0 pages are entirely empty. Look so bad ? However... i can't find anything in the log saying that slony is manually vacuuming. Should i restart slony ? -- Laurent "ker2x" Laborde Sysadmin & DBA at http://www.over-blog.com/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
