--- a/analyzeall.py Tue Feb 14 18:15:56 2012 +0100
+++ b/analyzeall.py Mon Feb 27 15:12:40 2012 +0100
@@ -1,4 +1,12 @@
#!/usr/bin/env python3.2
+"""
+analyzeall
+
+Analyze/vacuum all tables in selected schemas.
+See also "VACUUM ANALYZE VERBOSE;" query.
+Unlike that, this program skips pg_catalog etc.
+
+"""
from pgtoolkit import pgbrowser, toolbase
from pgtoolkit.highlight import highlight
@@ -10,6 +18,7 @@
self.parser.add_argument('-s', dest='schema', nargs='*', help='Schema filter')
self.parser.add_argument('--vacuum', action='store_true', help='Call VACUUM ANALYZE')
self.parser.add_argument('--full', action='store_true', help='Call VACUUM FULL ANALYZE')
+ self.target_isolation_level = 'autocommit'
self.init()
def main(self):