Re: when a table was last vacuumed

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: when a table was last vacuumed
Date: 2010-02-10 10:54:51
Message-ID: 4B72907B.2030207@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 10/02/2010 11:23, AI Rumman a écrit :
> But I am using Postgresql 8.1 and here no clumn named last_vacuum.
>

On this old release, the only way you can find such an information is
via the logfile and using DEBUG1 or DEBUG2 level. Not something I would
recommend for a production server.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yeb Havinga 2010-02-10 11:04:09 Re: Extending SQL in C using VARIABLE length type
Previous Message Carsten Kropf 2010-02-10 10:51:36 Re: Extending SQL in C using VARIABLE length type