]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
account: update ligfietser ssh key
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
index 77b1257ef2016f09c72a1169a6d1ed8e4adea3c1..ce027f6063833d855cb0a43f7d55a2c53b5e81a3 100644 (file)
@@ -5,10 +5,4 @@
 
 # Vaccum all tables with indices on integer arrays.
 # Agressive vacuuming seems to help against index bloat.
 
 # Vaccum all tables with indices on integer arrays.
 # Agressive vacuuming seems to help against index bloat.
-psql -q -d nominatim -c 'VACUUM ANALYSE search_name'
-psql -q -d nominatim -c 'VACUUM ANALYSE search_name_country'
-
-for i in `seq 0 246`; do
-  psql -q -d nominatim -c "VACUUM ANALYSE search_name_${i}"
-done
-
+psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name'