cron job for vacuuming intarray indices

diff --git a/utils/cron_vacuum.sh b/utils/cron_vacuum.sh
new file mode 100755 (executable)
index 0000000..f33e8bb
--- /dev/null
+++ b/utils/cron_vacuum.sh
@@ -0,0 +1,14 @@
+#!/bin/bash
+#
+# Vaccum all tables with indices on integer arrays.
+# Agressive vacuuming seems to help against index bloat.
+#
+
+psql -d nominatim -c 'VACUUM ANALYSE search_name' >/dev/null
+psql -d nominatim -c 'VACUUM ANALYSE search_name_country' >/dev/null
+psql -d nominatim -c 'VACUUM ANALYSE planet_osm_ways' >/dev/null
+
+for i in `seq 0 246`; do
+  psql -d nominatim -c "VACUUM ANALYSE search_name_${i}" >/dev/null
+done
+