diff -r 8636719a30f6 -r a8b7cd92f39f analyzeall.py --- 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):