Project

General

Profile

« Previous | Next » 

Revision 7061

make_analytical_db: ANALYZE each table after its created so that queries use index scans instead of seq scans

View differences:

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