From fa4e5513d14139732a807ffb96dfa2fbb1e01f53 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 2 Jan 2024 16:10:30 +0100 Subject: [PATCH] API: avoid engine disposal on startup --- nominatim/api/core.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/nominatim/api/core.py b/nominatim/api/core.py index 1c0c4423..c0b83f80 100644 --- a/nominatim/api/core.py +++ b/nominatim/api/core.py @@ -137,6 +137,10 @@ class NominatimAPIAsync: #pylint: disable=too-many-instance-attributes async with engine.begin() as conn: result = await conn.scalar(sa.text('SHOW server_version_num')) server_version = int(result) + if server_version >= 110000: + await conn.execute(sa.text("SET jit_above_cost TO '-1'")) + await conn.execute(sa.text( + "SET max_parallel_workers_per_gather TO '0'")) except (PGCORE_ERROR, sa.exc.OperationalError): server_version = 0 @@ -146,8 +150,6 @@ class NominatimAPIAsync: #pylint: disable=too-many-instance-attributes cursor = dbapi_con.cursor() cursor.execute("SET jit_above_cost TO '-1'") cursor.execute("SET max_parallel_workers_per_gather TO '0'") - # Make sure that all connections get the new settings - await engine.dispose() self._property_cache['DB:server_version'] = server_version -- 2.39.5