Postgres Pro
Downloads
Home   >   mailing lists

Thread: Autovacuum

Autovacuum

From
Glyn Astill
Date:
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?






      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

Re: Autovacuum

From
Guillaume Lelarge
Date:
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

Re: Autovacuum

From
Glyn Astill
Date:
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/