2008/3/18, Blair Bethwaite <blair.bethwaite@xxxxxxxxxxxxxxxxxxxxxx>:> 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@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
