Wed May 21 13:13:30 PDT 2008
- Previous message: [Slony1-general] Slony Vacuuming DB
- Next message: [Slony1-general] Slony Vacuuming DB
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In response to "Rafael Domiciano" <rafael.domiciano at gmail.com>: > My postgres set up is not configured to run autovacuum, I ran it at > midnigth. > Today, Slony not vacuumed my DB yet. > I had a big queue on Slony in the last week, could that happened because > this? I think you may be confused. As mentioned in the page I directed you to, Slony does not vacuum "your database", it only vacuums the tables that it uses for the purpose of replication. If this is slowing your database down, then you have improperly configured your PostgreSQL server, or insufficiently sized your hardware to handle replication. In any event, it sounds like more of a PostgreSQL performance question than a Slony question. > > 2008/5/21 Bill Moran <wmoran at collaborativefusion.com>: > > > In response to "Rafael Domiciano" <rafael.domiciano at gmail.com>: > > > > > > Frequently Slony is vacuuming my database, and I'm having to kill his > > > proccess because it's slowing the client-side application. > > > I tryied to find option that disables the vacuum but i'm unsucessful. > > > Someone know how to stop vacuum's Slony? > > > > This should be enough information for you to address any issues: > > http://cbbrowne.com/info/maintenance.html > > > > -- > > Bill Moran > > Collaborative Fusion Inc. > > http://people.collaborativefusion.com/~wmoran/<http://people.collaborativefusion.com/%7Ewmoran/> > > > > wmoran at collaborativefusion.com > > Phone: 412-422-3463x4023 > > > -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran at collaborativefusion.com Phone: 412-422-3463x4023 **************************************************************** IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. ****************************************************************
- Previous message: [Slony1-general] Slony Vacuuming DB
- Next message: [Slony1-general] Slony Vacuuming DB
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list