From: t-tomek <t-tomek@users.noreply.github.com>
Date: Wed, 21 Dec 2022 18:56:24 +0000 (+0100)
Subject: Update DB.php
X-Git-Tag: v4.3.0~119^2~1
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/e8d3c0a99ae747bc26d161762eb538466a7c01a3

Update DB.php
---

diff --git a/lib-php/DB.php b/lib-php/DB.php
index 8b51955d..d49e5149 100644
--- a/lib-php/DB.php
+++ b/lib-php/DB.php
@@ -47,12 +47,9 @@ class DB
         $this->connection->exec("SET DateStyle TO 'sql,european'");
         $this->connection->exec("SET client_encoding TO 'utf-8'");
         // Disable JIT and parallel workers. They interfere badly with search SQL.
-        if ($this->getPostgresVersion() < 11) {
-            $this->connection->exec("UPDATE pg_settings SET setting = -1 WHERE name = 'jit_above_cost'");
-            $this->connection->exec("UPDATE pg_settings SET setting = 0 WHERE name = 'max_parallel_workers_per_gather'");
-        } else {
+        $this->connection->exec("SET max_parallel_workers_per_gather TO 0");  
+        if ($this->getPostgresVersion() >= 11) {
             $this->connection->exec("SET jit_above_cost TO -1");
-            $this->connection->exec("SET max_parallel_workers_per_gather TO 0");    
         }
         
         $iMaxExecution = ini_get('max_execution_time');