Mon Sep 13 19:11:04 PDT 2004
- Previous message: [Slony1-general] Useful Maintenance note...
- Next message: [Slony1-general] Error in my switch over syntax for slonik?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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)
- Previous message: [Slony1-general] Useful Maintenance note...
- Next message: [Slony1-general] Error in my switch over syntax for slonik?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list