From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 2 Jan 2023 07:57:31 +0000 (+0100)
Subject: nominatim: remove vacuuming of sub search-name tables
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/f10f2d011fba16a7590eee3ab1d9261d725f0382

nominatim: remove vacuuming of sub search-name tables

They don't have an index on integer arrays anymore.
---

diff --git a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
index e1be595e9..ce027f606 100644
--- a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
+++ b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
@@ -6,8 +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'
-
-for i in `seq 0 250`; do
-  psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}"
-done
-