Function to get size of notification queue?

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Function to get size of notification queue?
Date: 2013-01-02 07:37:58
Message-ID: CADxJZo0k-ySn3OW5vH-nzJ7MKeL0cuOGrc2y3VETd8QKiyWGtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Boszormenyi Zoltan 2013-01-02 08:59:19 Re: [PATCH] Make pg_basebackup configure and start standby [Review]
Previous Message Hari Babu 2013-01-02 07:11:15 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