Revision 3075
Added by Aaron Marcuse-Kubitza over 12 years ago
| lib/sql.py | ||
|---|---|---|
| 528 | 528 |
# try again with next version of name |
| 529 | 529 |
|
| 530 | 530 |
if add_indexes_: add_indexes(db, into) |
| 531 |
|
|
| 532 |
# According to the PostgreSQL doc, "The autovacuum daemon cannot access and |
|
| 533 |
# therefore cannot vacuum or analyze temporary tables. [...] if a temporary |
|
| 534 |
# table is going to be used in complex queries, it is wise to run ANALYZE on |
|
| 535 |
# the temporary table after it is populated." |
|
| 536 |
# (http://www.postgresql.org/docs/9.1/static/sql-createtable.html) |
|
| 537 |
# If into is not a temp table, ANALYZE is useful but not required. |
|
| 531 | 538 |
analyze(db, into) |
| 532 | 539 |
|
| 533 | 540 |
return cur |
Also available in: Unified diff
sql.py: run_query_into(): Documented why analyze() must be run manually on newly populated temp tables