X-Git-Url: https://dev.renevier.net/?p=syj.git;a=blobdiff_plain;f=scripts%2Fupdategeonames.sh;h=04712fef09ed29c6378e1ce9a31e08d8119e02b2;hp=ff5c8cdfa1059d1f84cc17a4059a8ed30a092d54;hb=03f49f88786c9eefcb850927958646266f11a86d;hpb=d46d626700669a4c9a1e9ffc407fa89e6d6c7e21

diff --git a/scripts/updategeonames.sh b/scripts/updategeonames.sh
index ff5c8cd..04712fe 100755
--- a/scripts/updategeonames.sh
+++ b/scripts/updategeonames.sh
@@ -72,4 +72,5 @@ for line in $(cat ${GEONAMESXML##*/}); do
 done
 echo "INSERT INTO geonames (country, minlon, minlat, maxlon, maxlat) VALUES ('EU', -26, 34, 40, 68);" >> $TMPFILE
 echo "INSERT INTO geonames (country, minlon, minlat, maxlon, maxlat) VALUES ('AP', 90, -20, -140, 68);" >> $TMPFILE
+echo "VACUUM ANALYZE geonames;" >> $TMPFILE
 psql --set "ON_ERROR_STOP=1" -f $TMPFILE