Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group