Re: Autovacuum

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum
Date: 2008-05-02 15:14:24
Message-ID: 735517.65601.qm@web25809.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Aha thanks!

So the amount of dead tuples has to satisfy autovacuum_vacuum_scale_factor AND autovacuum_vacuum_threshold for it to kick off the autovacuum process!

I set autovacuum_vacuum_scale_factor to 0.02 and off it fired vacuuming everything :-)

----- Original Message ----
> From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
> Cc: pgsql-general(at)postgresql(dot)org
> Sent: Friday, 2 May, 2008 3:49:03 PM
> Subject: Re: [GENERAL] Autovacuum
>
> Glyn Astill a écrit :
> > Using 8.3.1
> >
> > No matter what I try I've never seen any evidence that autovacuum runs on my
> system.
> >
> > I set
> >
> > autovacuum_vacuum_threshold = 50
> >
> > Then run a process to do updates on a table, shouldn't autovacuum kick in
> after 50 updates?
> >
>
> Nope, it also depends on the number of rows of your table and on the
> configuration of the autovacuum_vacuum_scale_factor parameter.
>
> You should also configure log_autovacuum_min_duration to 0 to see the
> autovacuum operations.
>
> Regards.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

___________________________________________________________
Yahoo! For Good. Give and get cool things for free, reduce waste and help our planet. Plus find hidden Yahoo! treasure

http://green.yahoo.com/uk/earth-day/

Browse pgsql-general by date

  From Date Subject
Next Message Scott Miller 2008-05-02 15:34:29 Feature request
Previous Message Javier Olazaguirre 2008-05-02 15:13:59 Speed up repetitive queries