X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/eaf53e497a3a6e85cb4fec4431a8f72ddcf7a2c3..0bd6c1db76d2c21e8695ab37f3f5ea35a1a7ef65:/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb?ds=sidebyside diff --git a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb index 112159717..e1be595e9 100644 --- a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb +++ b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb @@ -6,7 +6,6 @@ # 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 250`; do psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}"