]> git.openstreetmap.org Git - chef.git/commitdiff
nominatim: remove vacuuming of sub search-name tables
authorSarah Hoffmann <lonvia@denofr.de>
Mon, 2 Jan 2023 07:57:31 +0000 (08:57 +0100)
committerSarah Hoffmann <lonvia@denofr.de>
Mon, 2 Jan 2023 07:58:07 +0000 (08:58 +0100)
They don't have an index on integer arrays anymore.

cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb

index e1be595e94c9c1280a33140e28795bc97abaeaf9..ce027f6063833d855cb0a43f7d55a2c53b5e81a3 100644 (file)
@@ -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
-