LISTEN/NOTIFY ultra slow speed
| От | Арсен Арутюнян |
|---|---|
| Тема | LISTEN/NOTIFY ultra slow speed |
| Дата | |
| Msg-id | 1647262405.342456086@f759.i.mail.ru обсуждение |
| Ответы |
Re: LISTEN/NOTIFY ultra slow speed
Re: LISTEN/NOTIFY ultra slow speed |
| Список | pgsql-general |
Hello! I'm having trouble with LISTEN/NOTIFY speed. Now I have about 100-200 (few?) clients who are actively messaging. But recently I started to notice a drop in speed. Changing the log_min_duration_statement parameter did not show slow queries in the log.
As it turned out, the pg_notify(text ,text) function
or the
NOTIFY text, 'text' queries takes an extremely long time (0.7-1.5sec),
but the select pg_notification_queue_usage() query always returns 0.
Please tell me what's the matter, where did I make a mistake?
What needs to be done to increase the speed of adding to the message queue?
--
Arsen Arutyunyan
Arsen Arutyunyan
В списке pgsql-general по дате отправления: