nominatim: increase page access cost

This is to deter postgresql from doing seq scans on huge tables.

diff --git a/roles/nominatim.rb b/roles/nominatim.rb
index b43ffbc4f75bbad40246988a8c0d46d0c1f82271..28df54786d73a7cf75e0fdeeaa90182aa8438117 100644 (file)
--- a/roles/nominatim.rb
+++ b/roles/nominatim.rb
@@ -28,7 +28,8 @@ default_attributes(
         :autovacuum_max_workers => "1",
         :max_parallel_workers_per_gather => "0",
         :maintenance_work_mem => "10GB",
-        :random_page_cost => "1.5",
+        :seq_page_cost => "2.0",
+        :random_page_cost => "3.0",
         :effective_cache_size => "60GB",
         :wal_level => "minimal",
         :max_wal_senders => "0"