X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c7f6c009e30d0b0be3670d0772176b83b0661e2a..5636881ff4e16aaf1849c0dd399a138b8638d6cc:/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb diff --git a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb index dacdbf631..ce027f606 100644 --- a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb +++ b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb @@ -6,9 +6,3 @@ # 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 - psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}" -done -