On 02/19/2016 06:01 AM, Jiří Hlinka wrote:
Hello,
I'd like to ask you whether there is a way how to monitor and log
details about NOTIFY queue? What do you use for this prupose?
In the official documentation I'm unable to find a way how to monitor
NOTIFY queue in more detail, at least size of this queue, which is
critical in case of filling up the queue, which will lead to stopping
the NOTIFY queue functionality.
Should have added from:
http://www.postgresql.org/docs/9.5/interactive/sql-notify.html
"Once the queue is half full you will see warnings in the log file
pointing you to the session that is preventing cleanup. In this case you
should make sure that this session ends its current transaction so that
cleanup can proceed"
Where the message is of form(from async.c):
(errmsg("NOTIFY queue is %.0f%% full", fillDegree * 100),
(minPid != InvalidPid ?
errdetail("The server process with
PID %d is among those with the oldest transactions.", minPid)
: 0),
(minPid != InvalidPid ?
errhint("The NOTIFY queue cannot be
emptied until that process ends its current transaction.")
: 0)));
Thanks,
Jiri
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
