I know that autovacuum daemon in available since PostgreSQL 8.1, but
as optional feature that need to be enabled explicitly. Starting from
PostgreSQL 8.3 it is enabled by default. I think that some properties
in postgresql.conf need to be changed (plus server restart/reload)
stats_start_collector, stats_row_level, autovacuum
Refer to http://www.postgresql.org/docs/8.1/static/runtime-config-autovacuum.html
2011/5/9 Machiel Richards <machielr(at)rdc(dot)co(dot)za>:
> Hi All
> One of our clients are running a combination of postgresql 8.1 and
> On the 8.3 databases I can run the following select in order to
> determine when last a table was autovacuumed:
> SELECT relname,last_autovacuum,last_autoanalyze from
> However this is not available on the 8.1 databases.
> Can someone please confirm whether autovacuum was available on
> version 8.1 and if so what the query would be for this?
> If autovacuum was not available, how would I go about in finding
> out when last a tables was actually vacuumed?
> Thank you in advance for any assistance in this.
In response to
pgsql-novice by date
|Next:||From: Birchall, Austen||Date: 2011-05-09 09:31:18|
|Subject: Seed database for import|
|Previous:||From: Machiel Richards||Date: 2011-05-09 07:23:32|
|Subject: Last autovacuum on postgresql 8.1|