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

From Andrew Chernow
Subject Re: Listen / Notify - what to do when the queue is full
Date
Msg-id 4B04A8AB.5080508@esilo.com
Whole thread Raw
In response to Re: Listen / Notify - what to do when the queue is full  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Listen / Notify - what to do when the queue is full
List pgsql-hackers
> We should probably also log the fact that we ran out of room, so that
> the DBA knows that they ahve a design issue.

Can't they just bump allowed memory and avoid a redesign?

> Alternately, it would be great to have a configuration option which
> would allow the DBA to choose any of 3 behaviors via GUC:
> 
> drop-oldest (as above)
> drop-largest (if we run out of room, drop the largest payloads first to
> save space)
> error (if we run out of room, error and rollback)
> 

I mentioned this up thread.  I completely agree that overflow behavior should be 
tunable.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Listen / Notify - what to do when the queue is full
Next
From: gabrielle
Date:
Subject: Review: psql-wrap-formatting/Unicode UTF-8 table formatting for psql text output