Thu Nov 26 01:26:33 PST 2009
- Previous message: [Slony1-general] bloated pg_listener
- Next message: [Slony1-general] bloated pg_listener
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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/
- Previous message: [Slony1-general] bloated pg_listener
- Next message: [Slony1-general] bloated pg_listener
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list