From e8d3c0a99ae747bc26d161762eb538466a7c01a3 Mon Sep 17 00:00:00 2001 From: t-tomek Date: Wed, 21 Dec 2022 19:56:24 +0100 Subject: [PATCH] Update DB.php --- lib-php/DB.php | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) 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'); -- 2.39.5