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

Reply via email to