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
eve=
rything :-)
----- Original Message ----
> From: Guillaume Lelarge <guillaume@[EMAIL PROTECTED]
>
> To: Glyn Astill <glynastill@[EMAIL PROTECTED]
>
> Cc: pgsql-general@[EMAIL PROTECTED]
> Sent: Friday, 2 May, 2008 3:49:03 PM
> Subject: Re: [GENERAL] Autovacuum
>=20
> Glyn Astill a =E9crit :
> > Using 8.3.1
> >=20
> > No matter what I try I've never seen any evidence that autovacuum runs
=
on my=20
> system.
> >=20
> > I set
> >=20
> > autovacuum_vacuum_threshold =3D 50
> >=20
> > Then run a process to do updates on a table, shouldn't autovacuum kick
=
in=20
> after 50 updates?
> >=20
>=20
> Nope, it also depends on the number of rows of your table and on the=20
> configuration of the autovacuum_vacuum_scale_factor parameter.
>=20
> You should also configure log_autovacuum_min_duration to 0 to see the=20
> autovacuum operations.
>=20
> Regards.
>=20
>=20
> --=20
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>=20
> --=20
> Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>=20
___________________________________________________________=20
Yahoo! For Good. Give and get cool things for free, reduce waste and help
o=
ur planet. Plus find hidden Yahoo! treasure=20
http://green.yahoo.com/uk/earth-day/
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
