]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
Expect munin to use an IPv6 socket
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
index dacdbf631411938312a2f5e55f06ecd935424cb7..e1be595e94c9c1280a33140e28795bc97abaeaf9 100644 (file)
@@ -6,9 +6,8 @@
 # Vaccum all tables with indices on integer arrays.
 # Agressive vacuuming seems to help against index bloat.
 psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name'
 # Vaccum all tables with indices on integer arrays.
 # Agressive vacuuming seems to help against index bloat.
 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
+for i in `seq 0 250`; do
   psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}"
 done
 
   psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}"
 done