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@xxxxxxxxxxxx> > To: Glyn Astill <glynastill@xxxxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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/
