Re: Is autovacuum on?

2008/3/18, Blair Bethwaite <blair(dot)bethwaite(at)infotech(dot)monash(dot)edu(dot)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