]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
Add includeSubDomains to HSTS header
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
index 77b1257ef2016f09c72a1169a6d1ed8e4adea3c1..112159717372f6f4566e8d5319a0443f7e846fdb 100644 (file)
@@ -5,10 +5,10 @@
 
 # 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'
+psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name_country'
 
-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