]> git.openstreetmap.org Git - chef.git/blob - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
Disable collection of bgwriter statistics for postgres 17
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
1 #!/bin/bash
2 #
3 # DO NOT EDIT - This file is being maintained by Chef
4
5
6 # Vaccum all tables with indices on integer arrays.
7 # Agressive vacuuming seems to help against index bloat.
8 psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name'