Re: LISTEN/NOTIFY benchmarks? - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: LISTEN/NOTIFY benchmarks?
Date
Msg-id Pine.LNX.4.21.0304301107330.5542-100000@linuxworld.com.au
Whole thread Raw
In response to Re: LISTEN/NOTIFY benchmarks?  (Sean Chittenden <sean@chittenden.org>)
Responses Re: LISTEN/NOTIFY benchmarks?  (Sean Chittenden <sean@chittenden.org>)
List pgsql-hackers
On Tue, 29 Apr 2003, Sean Chittenden wrote:

> > I'm not an expert on signals, not even a novice, so I might be
> > totally off base, but it seems like the Async Notification
> > implementation does not scale.  If it does not, does anyone have a
> > solution for the problem of signalling a each event in a possibly
> > very large set of events to a large number of clients?
> 
> <brainfart_for_the_archives> Hrm.... I should see about porting
> kqueue/kevent as a messaging buss for the listen/notify bits to
> postgresql... that does scale and it scales well to tens of thousands
> of connections a second (easily over 60K, likely closer to 1M is the
> limit)....  </brainfart_for_the_archives>

Except that it is FreeBSD specific -- being system calls and all -- if I
remember correctly. If you're going to move to a system like that, which
is a good idea, best move to a portable system.

Thanks,

Gavin



pgsql-hackers by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: LISTEN/NOTIFY benchmarks?
Next
From: Sean Chittenden
Date:
Subject: Re: LISTEN/NOTIFY benchmarks?