-
Notifications
You must be signed in to change notification settings - Fork 432
-
I noticed that the first request from async pg.pool is slow.
Found a solution here:
#794
But when I execute:
await asyncpg.create_pool(
max_size=self.max_size,
min_size=1,
host=self._host,
port=self._port,
user=self._username,
password=self._password,
database=self._schema_name,
init=self._init_connection,
max_inactive_connection_lifetime=3,
command_timeout=60,
server_settings={'jit': 'off'}
)
it raises Exception:
asyncpg.exceptions.ProtocolViolationError: unsupported startup parameter: jit
Further search showed that the problem may be in pgbouncer. Is it possible to fix it somehow?
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
FyZzyss
Oct 12, 2021
Add jit = off to config
Replies: 1 comment 2 replies
-
Add jit = off to config
Beta Was this translation helpful? Give feedback.
All reactions
2 replies
-
to config of pgbouncer?
Beta Was this translation helpful? Give feedback.
All reactions
-
👀 2
-
Have you found a solution?
Beta Was this translation helpful? Give feedback.
All reactions
Answer selected by
FyZzyss
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment