Laurent Laborde kerdezixe at gmail.com
Thu Nov 26 01:26:33 PST 2009
On Wed, Nov 25, 2009 at 2:33 PM, Brad Nicholson
<bnichols at ca.afilias.info> wrote:
> On Wed, 2009-11-25 at 09:33 +0100, Laurent Laborde wrote:
>> On Mon, Nov 23, 2009 at 5:37 PM, Brad Nicholson
>> <bnichols at ca.afilias.info> wrote:
>> >
>> > If the vacuums are running, do you have a lot of long running
>> > transactions against this database?
>>
>> nope :)
>
> -Did you disable vacuums in the slon?
> -Do you have autovacuum enabled?  If so, post your autovac settings.
> -If autovac is on, did you tell it to not process pg_listener?
> -do you have appropriate logging set so the vacuums (either slon
> triggers or autovac) will be logged?

I can't find a correct documentation about *how* to activate "vacuum
from slony".
If i understand correctly, just disabling the autovacuum on thoses
tables should active the slony vacuum on them ?

-- 
Laurent "ker2x" Laborde
Sysadmin & DBA at http://www.over-blog.com/


More information about the Slony1-general mailing list