Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread kjsteuer
Thanks for the timely response! On Mon, Jun 15, 2015 at 2:07 PM Brendan Jurd [via PostgreSQL] ml-node+s1045698n5853928...@n5.nabble.com wrote: Hi Kevin, I never found a direct solution to this problem. I still feel that a function to find the size of the notification queue would be a handy

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Brendan Jurd
Hi Kevin, I never found a direct solution to this problem. I still feel that a function to find the size of the notification queue would be a handy feature to have, and I would be willing to take a shot at writing such a feature. However, given the tumbleweed/ response to my original email,

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Alvaro Herrera
Brendan Jurd wrote: Hi Kevin, I never found a direct solution to this problem. I still feel that a function to find the size of the notification queue would be a handy feature to have, and I would be willing to take a shot at writing such a feature. However, given the tumbleweed/ response

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread kjsteuer
Hi BJ, What approach did you end up using? Thanks, Kevin -- View this message in context: http://postgresql.nabble.com/Function-to-get-size-of-notification-queue-tp5738461p5853923.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Brendan Jurd
On Tue, 16 Jun 2015 at 05:36 Merlin Moncure mmonc...@gmail.com wrote: On Mon, Jun 15, 2015 at 2:12 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Brendan Jurd wrote: However, given the tumbleweed/ response to my original email, it's likely that effort would be a waste of time. I

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Merlin Moncure
On Mon, Jun 15, 2015 at 2:12 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Brendan Jurd wrote: Hi Kevin, I never found a direct solution to this problem. I still feel that a function to find the size of the notification queue would be a handy feature to have, and I would be willing to

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Merlin Moncure
On Mon, Jun 15, 2015 at 3:16 PM, Brendan Jurd dire...@gmail.com wrote: On Tue, 16 Jun 2015 at 05:36 Merlin Moncure mmonc...@gmail.com wrote: On Mon, Jun 15, 2015 at 2:12 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Brendan Jurd wrote: However, given the tumbleweed/ response to my

Re: [HACKERS] Function to get size of notification queue?

2015-06-15 Thread Brendan Jurd
On Tue, 16 Jun 2015 at 07:52 Merlin Moncure mmonc...@gmail.com wrote: It goes back to the adage, 'Everyone wants to be an author but nobody wants to write'. A more accurate version would be Everyone wants to be an author, some want to write, but nobody likes being rejected by publishers.

[HACKERS] Function to get size of notification queue?

2013-01-01 Thread Brendan Jurd
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