]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
nominatim: update address level table on git changes
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
index 77b1257ef2016f09c72a1169a6d1ed8e4adea3c1..e1be595e94c9c1280a33140e28795bc97abaeaf9 100644 (file)
@@ -5,10 +5,9 @@
 
 # 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'
+psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name'
 
 
-for i in `seq 0 246`; do
-  psql -q -d nominatim -c "VACUUM ANALYSE search_name_${i}"
+for i in `seq 0 250`; do
+  psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}"
 done
 
 done