From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 24 Aug 2023 09:03:35 +0000 (+0200)
Subject: nominatim: increase page access cost
X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/c98f0c903fdfe9fbe8aef12dae4ecd74f6a859fa

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 b43ffbc4f..28df54786 100644
--- 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"