]> git.openstreetmap.org Git - chef.git/commitdiff
nominatim: increase seq_scan cost even more
authorSarah Hoffmann <lonvia@denofr.de>
Thu, 24 Aug 2023 09:33:44 +0000 (11:33 +0200)
committerSarah Hoffmann <lonvia@denofr.de>
Thu, 24 Aug 2023 09:33:44 +0000 (11:33 +0200)
roles/nominatim.rb

index 28df54786d73a7cf75e0fdeeaa90182aa8438117..e79a7fce2bb141ce63c3d4a690f255cfa931134d 100644 (file)
@@ -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",