X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/15f9e397dd81dca6aae5cc6d70e670e79a951ce8..50352c634da0b44bd595a278406cd9654ce94d86:/lib-php/DB.php diff --git a/lib-php/DB.php b/lib-php/DB.php index f5fea7f8..553d9452 100644 --- a/lib-php/DB.php +++ b/lib-php/DB.php @@ -47,17 +47,14 @@ 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 jit_above_cost TO -1"); - $this->connection->exec("SET max_parallel_workers_per_gather TO 0"); + $this->connection->exec('SET max_parallel_workers_per_gather TO 0'); + if ($this->getPostgresVersion() >= 11) { + $this->connection->exec('SET jit_above_cost TO -1'); } $iMaxExecution = ini_get('max_execution_time'); if ($iMaxExecution > 0) { - $conn->setAttribute(\PDO::ATTR_TIMEOUT, $iMaxExecution); // seconds + $this->connection->setAttribute(\PDO::ATTR_TIMEOUT, $iMaxExecution); // seconds } return true;