Re: LISTEN/NOTIFY benchmarks?

Поиск
Список
Период
Сортировка
От prashanth@jibenetworks.com
Тема Re: LISTEN/NOTIFY benchmarks?
Дата
Msg-id 20030430002735.GA4046@prashanth.jibenetworks.com
обсуждение исходный текст
Ответ на Re: LISTEN/NOTIFY benchmarks?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Apr 29, 2003 at 06:21:15PM -0400, Tom Lane wrote:
> prashanth@jibenetworks.com writes:
> > If the listening backend had registered tens of thousands of LISTENs,
> > it would be sent an equivalent number of signals during a single run
> > of AtCommit_Notify().
> 
> Not unless the notifier had notified all tens of thousands of condition
> names in a single transaction.

Unfortunately, that is a possibility in our application.  We are now
working around this non-scalability.

Regardless, it would seem redundant to send more than one SIG_USR2 to the
recipient backend in that loop.

-- prashanth



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "Adding missing from clause"
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: LISTEN/NOTIFY benchmarks?