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
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.. |