From f10f2d011fba16a7590eee3ab1d9261d725f0382 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 2 Jan 2023 08:57:31 +0100 Subject: [PATCH] nominatim: remove vacuuming of sub search-name tables They don't have an index on integer arrays anymore. --- .../nominatim/templates/default/vacuum-db-nominatim.erb | 5 ----- 1 file changed, 5 deletions(-) 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 - -- 2.39.5