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

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@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/