From: jody brownell <jody.brownell@q1labs.com>
To: Csaba Nagy <nagy@ecircle-ag.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Date: Wed, 21 Jun 2006 13:49:49 -0300
Message-ID: <200606211349.49305.jody.brownell@q1labs.com> (raw)
In-Reply-To: <1150908279.3309.56.camel@coppola.muc.ecircle.de>
References: <200606211052.43227.jody.brownell@q1labs.com>
<200606211339.33262.jody.brownell@q1labs.com>
<1150908279.3309.56.camel@coppola.muc.ecircle.de>
block and row are always configured on - they are my friend :)
thanks
On Wednesday 21 June 2006 13:44, Csaba Nagy wrote:
> On Wed, 2006-06-21 at 18:39, jody brownell wrote:
> > that is exactly what I am seeing, one process, no change, always in idle while the others are constantly
> > changing their state.
> >
> > looks like someone opened a tx then is blocking on a queue lock or something. dang.
>
> Don't forget to check the statistics collector settings (see below), if
> that is not correct then autovacuum is indeed not working correctly... I
> should have put that on the beginning of the mail so you won't overlook
> it ;-)
>
> > >
> > > Oh, just occured to me... in order to use autovacuum you also need to
> > > enable the statistics collector on row level:
> > >
> > > stats_start_collector = on
> > > stats_row_level = on
> > >
> > > See also:
> > > http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM
> > >
> > > This was not mentioned in the settings in your original post, so I guess
> > > you didn't touch that, and I think they are disabled by default.
> > >
> > > If this is disabled, you should enable it and "pg_ctl reload ....", that
> > > should fix the problem.
> > >
> > > Cheers,
> > > Csaba.
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jody.brownell@q1labs.com, nagy@ecircle-ag.com
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
In-Reply-To: <200606211349.49305.jody.brownell@q1labs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox