Is autovacuum on?

From: "Blair Bethwaite" <blair(dot)bethwaite(at)infotech(dot)monash(dot)edu(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Is autovacuum on?
Date: 2008-03-18 00:13:00
Message-ID: ab42a7c0803171713w3aefd0fbi8ede5f9db6bf2a59@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've just upgraded to 8.3 and am looking at using autovacuum. We have
a long running application with high update frequency that
periodically issues vacuum commands itself. I'd like to be able to add
code to the app like:
if pg.autovacuum == "on":
self.routine_vacuuming = False
else:
self.routine_vacuuming = True
so that we can avoid manually issuing vacuum commands at sites where
Postgresql is running autovacuum.
But so far I haven't been able to find a way for a non-privileged user
to query the autovacuum status, is this possible?

Also, the routine-vacuuming section of the manual states that the
purpose of the autovacuum daemon is to periodically issue VACUUM and
ANALYZE commands - am I correct in thinking this implies that it will
not issue VACUUM FULL commands?

Cheers,
-Blair

--
In science one tries to tell people, in such a way
as to be understood by everyone, something that
no one ever knew before. But in poetry, it's the
exact opposite.
- Paul Dirac

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-18 00:33:30 Re: Updating
Previous Message Bruce Momjian 2008-03-17 23:49:40 Re: storage size of "bit" data type..