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" <drees76 at gmail.com>
Subj:  Re: [Slony1-general] Dead tuples on the slave
Date:  Thu Feb 7, 2008 20:26
Size:  504 bytes
To:  "Christian Storm" <storm at iparadigms.com>
cc:  slony1-general at lists.slony.info

On Feb 7, 2008 4:16 PM, Christian Storm <storm at iparadigms.com> 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
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general