Is autovacuum on?
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
2008/3/18, Blair Bethwaite <blair.bethwaite@infotech.monash.edu.au>:
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?
yes.
select setting from pg_settings where name = 'autovacuum';
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?
Yes, you're correct.
--
Filip Rembiałkowski
On Tue, Mar 18, 2008 at 3:20 PM, Filip Rembiałkowski
<plk.zuber@gmail.com> wrote:
yes.
select setting from pg_settings where name = 'autovacuum';
Ah ha, thankyou! I assumed there must have been a view for the
settings, I guess I missed it when I looked at the various pg_* views.
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
On Mar 17, 2008, at 11:25 PM, Blair Bethwaite wrote:
On Tue, Mar 18, 2008 at 3:20 PM, Filip Rembiałkowski
<plk.zuber@gmail.com> wrote:yes.
select setting from pg_settings where name = 'autovacuum';Ah ha, thankyou! I assumed there must have been a view for the
settings, I guess I missed it when I looked at the various pg_* views.
Or, a simple:
SHOW autovacuum;
will to the trick. http://www.postgresql.org/docs/8.2/interactive/sql-show.html
Erik Jones
DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
On Wed, Mar 19, 2008 at 1:29 AM, Erik Jones <erik@myemma.com> wrote:
SHOW autovacuum;
That's even better, thanks Erik.
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