It not only can, it definitely will hurt performance. A Slony replica experiences the same updates, row per row, as the origin did. This means that the need for vacuuming is exactly the same.
Jan -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin -----Original Message----- From: "David Rees" <[EMAIL PROTECTED]> Subj: Re: [Slony1-general] Dead tuples on the slave Date: Thu Feb 7, 2008 20:26 Size: 504 bytes To: "Christian Storm" <[EMAIL PROTECTED]> cc: [email protected] On Feb 7, 2008 4:16 PM, Christian Storm <[EMAIL PROTECTED]> wrote: > However, on one of the slaves I saw a lot of table bloat. Can this hurt > performance? It can. Do you not vacuum the slave database? Autovacuum would help you out here at a minimum on the slaves if you didn't want to bother with doing a full vacuum analysis. -Dave _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
