Re: Notify enhancement

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Notify enhancement
Date: 2006-12-04 15:02:11
Message-ID: 45743873.1000901@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>> Alvaro Herrera wrote:
>>
>>> What will happen when the ring is full? NOTIFY blocks?
>>>
>>>
>> An error, I think, don't you? Blocking seems totally unacceptable.
>>
>
> That seems like a curious answer. Imagine the documentation:
> "NOTIFY may fail for no reason whatsoever." I'd vote for blocking.
> Otherwise, apps have to treat NOTIFY as an unreliable communication
> mechanism, which reduces its use-case to approximately nil.
>
>
>

OK, good point. I guess I'm a bit concerned about providing a possible
DOS vector, but it could be either way.

How about Alvaro's suggestion of spilling to disk?

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2006-12-04 15:02:12 Re: Notify enhancement
Previous Message Timasmith 2006-12-04 14:52:00 Re: postgresql roadmap for horizontal scalability?