]> git.openstreetmap.org Git - chef.git/blob - cookbooks/nominatim/templates/default/clean-db-nominatim.erb
replication for nominatim servers
[chef.git] / cookbooks / nominatim / templates / default / clean-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 nominatim -c 'VACUUM ANALYSE search_name'
9 psql -q -d nominatim -c 'VACUUM ANALYSE search_name_country'
10
11 for i in `seq 0 246`; do
12   psql -q -d nominatim -c "VACUUM ANALYSE search_name_${i}"
13 done
14
15 <% if node[:postgres][:settings][:archive_mode] == "on" -%>
16
17 # Cleanup archive directory
18 find -L /data/postgresql-archive -mtime +3 -print0 | xargs -0r rm
19
20 <% end -%>