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/