=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= <aru...@bk.ru> writes:
> 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.
What PG version is this exactly? What is in $PGDATA/pg_notify/ ?
regards, tom lane
