From c98f0c903fdfe9fbe8aef12dae4ecd74f6a859fa Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 24 Aug 2023 11:03:35 +0200
Subject: [PATCH] nominatim: increase page access cost

This is to deter postgresql from doing seq scans on huge tables.
---
 roles/nominatim.rb | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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"
-- 
2.39.5