Ubuntu Geonames

Merge lp:~gnuoy/ubuntu-geonames/analyze-tables into lp:ubuntu-geonames

  1. analyze-tables
  2. Merge into trunk
Proposed by Liam Young
Status: Merged
Merged at revision: 29
Proposed branch: lp:~gnuoy/ubuntu-geonames/analyze-tables
Merge into: lp:ubuntu-geonames
Diff against target: 13 lines (+4/-0)
1 file modified
import-geonames.sh (+4/-0)
To merge this branch: bzr merge lp:~gnuoy/ubuntu-geonames/analyze-tables
Reviewer Review Type Date Requested Status
Dimitri John Ledkov Approve
Review via email: mp+185536@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Thanks a lot for this branch. I'll merge this & ask for deployment, today.

review: Approve
Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Tested and confirmed it's working / not breaking anything.

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'import-geonames.sh'
2--- import-geonames.sh 2013-09-13 14:15:45 +0000
3+++ import-geonames.sh 2013-09-13 15:54:24 +0000
4@@ -148,6 +148,10 @@
5 CREATE INDEX geoname_admin1codes_code_idx${LOAD_POSTFIX} ON admin1codes${LOAD_POSTFIX}(code);
6 CREATE INDEX geoname_countryinfo_isoalpha2_idx${LOAD_POSTFIX} ON countryinfo${LOAD_POSTFIX}(iso_alpha2);
7 CREATE INDEX geoname_alternatename_idx${LOAD_POSTFIX} ON alternatename${LOAD_POSTFIX}(alternatenameId);
8+ANALYZE geoname${LOAD_POSTFIX};
9+ANALYZE admin1codes${LOAD_POSTFIX};
10+ANALYZE countryinfo${LOAD_POSTFIX};
11+ANALYZE alternatename${LOAD_POSTFIX};
12 COMMIT;
13 EOT
14

Subscribers

People subscribed via source and target branches

to all changes: