Tue Sep 14 00:49:34 PDT 2004
- Previous message: [Slony1-general] Useful Maintenance note...
- Next message: [Slony1-general] Useful Maintenance note...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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? -Dom -- | Semantico: creators of major online resources | | URL: http://www.semantico.com/ | | Tel: +44 (1273) 722222 / Fax: +44 (1273) 723232 | | Address: 33 Bond St., Brighton, Sussex, BN1 1RD, UK. |
- Previous message: [Slony1-general] Useful Maintenance note...
- Next message: [Slony1-general] Useful Maintenance note...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list