Revision 7061
Added by Aaron Marcuse-Kubitza over 11 years ago
| bin/make_analytical_db | ||
|---|---|---|
| 17 | 17 |
-- Create $table |
| 18 | 18 |
TRUNCATE $public_table; |
| 19 | 19 |
INSERT INTO $public_table SELECT * FROM ${public_table}_view;
|
| 20 |
ANALYZE $public_table; |
|
| 20 | 21 |
|
| 21 | 22 |
-- Create $analyt_table view pointing to table in $public |
| 22 | 23 |
DROP VIEW IF EXISTS $analyt_table; |
Also available in: Unified diff
make_analytical_db: ANALYZE each table after its created so that queries use index scans instead of seq scans