From 042df4198a11da8456a3c192d3fe3f4726041612 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 22 Dec 2021 08:59:31 +0100 Subject: [PATCH] disable JIT and parallel workers on search frontend Bad query planning now also interferes with queries for search and reverse. --- lib-php/DB.php | 3 +++ 1 file changed, 3 insertions(+) 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 -- 2.39.5