From 244b6fcef605c48cbf83eb2fa4a7b01e1e3bcbdf Mon Sep 17 00:00:00 2001
From: t-tomek <t-tomek@users.noreply.github.com>
Date: Wed, 2 Nov 2022 14:11:52 +0100
Subject: [PATCH] Update DB.php

Use SET instead of UPDATE queries to support read only databases
---
 lib-php/DB.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib-php/DB.php b/lib-php/DB.php
index 6b6326b0..fc9e12a9 100644
--- a/lib-php/DB.php
+++ b/lib-php/DB.php
@@ -47,8 +47,8 @@ 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'");
+        $conn->exec("SET jit_above_cost TO -1");
+        $conn->exec("SET max_parallel_workers_per_gather TO 0");
         $iMaxExecution = ini_get('max_execution_time');
         if ($iMaxExecution > 0) {
             $conn->setAttribute(\PDO::ATTR_TIMEOUT, $iMaxExecution); // seconds
-- 
2.39.5