Re: Listen / Notify rewrite - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Listen / Notify rewrite
Date
Msg-id 4AFD8689.9030603@dunslane.net
Whole thread Raw
In response to Re: Listen / Notify rewrite  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Listen / Notify rewrite
List pgsql-hackers

Merlin Moncure wrote:
> On Fri, Nov 13, 2009 at 10:00 AM, Andrew Chernow <ac@esilo.com> wrote:
>   
>> I think the original OP was close.  The structure can still be fixed length
>> but maybe we can bump it to 8k (BLCKSZ)?
>>     
>
> The problem with this (which I basically agree with) is that this will
> greatly increase the size of the queue for all participants of this
> feature if they use the payload or not.  I think it boils down to
> this: is there a reasonably effective way of making the payload
> variable length (now or in the future)?  If not, let's compromise and
> maybe go with a larger size, maybe 256 or 512 bytes.
>
>
>   

My original intention was to have the queue as a circular buffer where 
the size of the entries was variable, but possibly bounded. Certainly 
using fixed length records of large size seems somewhat wasteful.

But maybe that doesn't fit with what Joachim has done.

Incidentally, I'd like to thank Joachim personally for having done this 
work, that I have been trying to get to for a couple of years, and that 
circumstances kept conspiring to prevent me from doing. It's been a big 
monkey on my back.

cheers

andrew


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Experimental patch: generating BKI revisited
Next
From: Tom Lane
Date:
Subject: Re: Check constraint on domain over an array not executed for array literals