Please keep the mailing list in the conversation, and please don't
top-post.

In response to "Rafael Domiciano" <rafael.domiciano at gmail.com>:
>
> Bill, are you saying that even autovacuum in postgresql.conf is disabled,
> Slony does vacuum in the tables that it uses?

Yes.  Slony is not autovaccum, they are independent of one another.

> So, there's how to disabled the vacuum's Slony?

There is no way that I know of.

> I have a proccess at
> midnigth that does a "vacuumdb -a -v -z -f", so I don't need Slony's vacuum
> at midday.

That statement is incorrect.

First of, scheduled VACUUM FULLs are not recommended as they cause index
bloating, require aggressive locking, put a heavy load on the server, and
are not an effective method of ongoing maintenance.

Secondly, unless you have a lot more information than you're providing,
you don't _know_ that vacuuming once a day is often enough, and I _highly_
doubt that it is.

> 
> 2008/5/21 Bill Moran <wmoran at collaborativefusion.com>:
> 
> > 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/>
> > <http://people.collaborativefusion.com/%7Ewmoran/>
> > > >
> > > > wmoran at collaborativefusion.com
> > > > Phone: 412-422-3463x4023
> > > >
> > >
> >
> >
> > --
> > Bill Moran
> > Collaborative Fusion Inc.
> > http://people.collaborativefusion.com/~wmoran/<http://people.collaborativefusion.com/%7Ewmoran/>
> >
> > 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.
> > ****************************************************************
> >
> 


-- 
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.
****************************************************************