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

[Liam Young]

[Dimitri John Ledkov (xnox)]

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

review: Approve

[Dimitri John Ledkov (xnox)]

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

review: Approve

=== modified file 'import-geonames.sh'
--- import-geonames.sh	2013-09-13 14:15:45 +0000
+++ import-geonames.sh	2013-09-13 15:54:24 +0000
@@ -148,6 +148,10 @@
 CREATE INDEX geoname_admin1codes_code_idx${LOAD_POSTFIX} ON admin1codes${LOAD_POSTFIX}(code);
 CREATE INDEX geoname_countryinfo_isoalpha2_idx${LOAD_POSTFIX} ON countryinfo${LOAD_POSTFIX}(iso_alpha2);
 CREATE INDEX geoname_alternatename_idx${LOAD_POSTFIX} ON alternatename${LOAD_POSTFIX}(alternatenameId);
+ANALYZE geoname${LOAD_POSTFIX};
+ANALYZE admin1codes${LOAD_POSTFIX};
+ANALYZE countryinfo${LOAD_POSTFIX};
+ANALYZE alternatename${LOAD_POSTFIX};
 COMMIT;
 EOT