2008/3/18, Blair Bethwaite <[EMAIL PROTECTED]>: > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general