Brad Nicholson bnichols at ca.afilias.info
Wed Nov 25 05:33:57 PST 2009
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?

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




More information about the Slony1-general mailing list