From 904e193093df997056955295ad2d270dfe71bf49 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 24 Aug 2023 11:33:44 +0200 Subject: [PATCH] nominatim: increase seq_scan cost even more --- roles/nominatim.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/roles/nominatim.rb b/roles/nominatim.rb index 28df54786..e79a7fce2 100644 --- a/roles/nominatim.rb +++ b/roles/nominatim.rb @@ -28,7 +28,7 @@ default_attributes( :autovacuum_max_workers => "1", :max_parallel_workers_per_gather => "0", :maintenance_work_mem => "10GB", - :seq_page_cost => "2.0", + :seq_page_cost => "3.0", :random_page_cost => "3.0", :effective_cache_size => "60GB", :wal_level => "minimal", -- 2.39.5