Re: Autovacuum

Aha thanks!

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

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

----- Original Message ----
> From: Guillaume Lelarge <guillaume@lelarge.info>
> To: Glyn Astill <glynastill@yahoo.co.uk>
> Cc: pgsql-general@postgresql.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@postgresql.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/