Christopher Browne cbbrowne
Mon Sep 13 19:11:04 PDT 2004
Dominic Mitchell <dom at semantico.com> writes:

> Christopher Browne wrote:
>> We've noticed that the heavy use of NOTIFY by Slony-I means that there
>> are Plenty O Dead Tuples in the system table pg_listener.
>> For now, we're vacuuming it fairly voraciously in our local "regular
>> maintenance regimen."  It's more than likely that this should be
>> rolled into the regular vacuums done by the slon engines.  I'll see if
>> I can make up a patch for CVS head...
>
> Woudl that be taken care of automatically if you're running 
> pg_autovacuum?  Or does it not work with tables in the system catalog?

It ought to cope with it; we're not using pg_autovacuum in production,
so I'm not certain.  We're not testing that, of late, so there's not
some place to really check that...
-- 
select 'cbbrowne' || '@' || 'ca.afilias.info';
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


More information about the Slony1-general mailing list