Skip site navigation (1) Skip section navigation (2)

Re: Last autovacuum on postgresql 8.1

From: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
To: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Last autovacuum on postgresql 8.1
Date: 2011-05-09 09:21:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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)
such as:

stats_start_collector, stats_row_level, autovacuum

Refer to

Grzegorz Szpetkowski

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
> 8.3.
>         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
> pg_stat_user_tables;
>         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.
> Regards
> Machiel

In response to


pgsql-novice by date

Next:From: Birchall, AustenDate: 2011-05-09 09:31:18
Subject: Seed database for import
Previous:From: Machiel RichardsDate: 2011-05-09 07:23:32
Subject: Last autovacuum on postgresql 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group