Thank you for the response.
I had a look on some of the servers and the autovacuum,etc... is in
I am however still not able to find where / how I can find out when
the last autovacuum occured?
Any more suggestions?
From: Grzegorz Szpetkowski <email@example.com>
To: Machiel Richards <firstname.lastname@example.org>
Subject: Re: [NOVICE] Last autovacuum on postgresql 8.1
Date: Mon, 9 May 2011 11:21:44 +0200
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 <email@example.com>:
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.