From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 3 Jan 2022 14:13:57 +0000 (+0100)
Subject: Merge pull request #2559 from lonvia/disable-jit-in-queries
X-Git-Tag: v4.1.0~103
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/e407558f767d1c3930624d2186c6c9934ab8a26b?hp=ab6f35d83a350ead4eb12b59c4cbc050e48f93ee

Merge pull request #2559 from lonvia/disable-jit-in-queries

Disable JIT and parallel workers on search frontend
---

diff --git a/lib-php/DB.php b/lib-php/DB.php
index 03ee6f1b..8e307b19 100644
--- a/lib-php/DB.php
+++ b/lib-php/DB.php
@@ -38,6 +38,9 @@ class DB
 
         $conn->exec("SET DateStyle TO 'sql,european'");
         $conn->exec("SET client_encoding TO 'utf-8'");
+        // Disable JIT and parallel workers. They interfere badly with search SQL.
+        $conn->exec("UPDATE pg_settings SET setting = -1 WHERE name = 'jit_above_cost'");
+        $conn->exec("UPDATE pg_settings SET setting = 0 WHERE name = 'max_parallel_workers_per_gather'");
         $iMaxExecution = ini_get('max_execution_time');
         if ($iMaxExecution > 0) {
             $conn->setAttribute(\PDO::ATTR_TIMEOUT, $iMaxExecution); // seconds