Revision 10829
Added by Aaron Marcuse-Kubitza over 11 years ago
| lib/db_xml.py | ||
|---|---|---|
| 225 | 225 |
in_table.set_srcs([in_table], overwrite=False) |
| 226 | 226 |
db.src = strings.ustr(in_table) |
| 227 | 227 |
|
| 228 |
db.autoanalyze = True # but don't do this in row-based import |
|
| 229 | 228 |
db.autoexplain = True # but don't do this in row-based import |
| 230 | 229 |
|
| 231 | 230 |
# Subset and partition in_table |
Also available in: Unified diff
bugfix: lib/db_xml.py: put_table(): turned off db.autoanalyze, since forcing an ANALYZE after every bulk insert is inefficient for small datasources. the default autovacuum settings in schemas/postgresql.conf should be fine; however, the frequency and/or threshold may need to be increased if autovacuum does not ANALYZE frequently enough to replace db.autoanalyze.