Re: Listen / Notify - what to do when the queue is full - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Listen / Notify - what to do when the queue is full
Date
Msg-id 4041.1258602238@sss.pgh.pa.us
Whole thread Raw
In response to Re: Listen / Notify - what to do when the queue is full  (Andrew Chernow <ac@esilo.com>)
Responses Re: Listen / Notify - what to do when the queue is full
List pgsql-hackers
Andrew Chernow <ac@esilo.com> writes:
> Tom Lane wrote:
>> There is only one correct overflow behavior.

> I count three.

Waiting till you can insert is reasonable (especially if we have some
behavior that nudges other backends to empty the queue).  If by "skip"
you mean losing the notify but still committing, that's incorrect.
There is no room for debate about that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Not safe to send CSV data" message
Next
From: Andrew Dunstan
Date:
Subject: Re: "Not safe to send CSV data" message