[Pkg-postgresql-public] 8.0.3 pg_autovacuum not working

Thomas Mueller gm-pkg-postgresql@tmueller.com
Tue, 07 Jun 2005 11:00:43 +0200

Stephen Frost wrote:
> * Thomas Mueller wrote:
>>>I've installed Postgresql 8.0.3 on Sarge. The pg server works fine but I
>>>think the autovacuum daemon doesn't, at least it doesn't log anything.

>>I've set avac_debug=999 (I found no documentation what's the maximum) in
>>the config but nothing is logged.
>>If I start the daemon manually logging works:
>>su postgres -c "/usr/lib/postgresql/8.0/bin/pg_autovacuum -p 5432 -L
>>/tmp/avc.log -d 999"
> Does it actually do anything?

Yes it works - but in no useful way, but that's the way the
documentation describes (if I understand it right):

- If the number of (deletes + updates) > VacuumThreshold, then a
  vacuum analyze is performed.

VacuumThreshold is equal to:
    vacuum_base_value + (vacuum_scaling_factor * "number of tuples in
the table")

vacuum_base_value and vacuum_scaling_factor are integers (default 1000
and 2), so the VacuumThreshold is at least the number of tuples.

I have a mail database with 200.000 tuples where mails are inserted and
deleted - so the first vacuum is done after 200.000 have been deleted? A
scaling factor of 0.1 would make more sense?

But that's no problem of the debian package.

http://www.tmueller.com for pgp key (95702B3B)