Postgres Pro
Downloads
Home   >   mailing lists

Function to get size of notification queue? - Mailing list pgsql-hackers

From Brendan Jurd
Subject Function to get size of notification queue?
Date
Msg-id CADxJZo0k-ySn3OW5vH-nzJ7MKeL0cuOGrc2y3VETd8QKiyWGtg@mail.gmail.com
Whole thread Raw
Responses Re: Function to get size of notification queue?
List pgsql-hackers
Tree view 
Hi folks,

I have a project which uses Postgres asynchronous notifications pretty
heavily.  It has a particularly Fun failure mode which causes the
notification queue to fill up.  To better debug this problem I'd like
to be able to monitor the size of the notification queue over time.

It doesn't look like we have a pg_notify_queue_size() or equivalent.
Should we?  Or would I be better off just watching the size of the
pg_notify/ directory on disk?

Cheers,
BJ

pgsql-hackers by date:

Previous
From: Hari Babu
Date:
Subject: Re: Review of "pg_basebackup and pg_receivexlog to use non-blocking socket communication", was: Re: Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: [PATCH] Make pg_basebackup configure and start standby [Review]