Re: notify duplicate elimination performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: notify duplicate elimination performance
Дата
Msg-id 17322.1391888120@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: notify duplicate elimination performance  (Hardy Falk <hardy.falk@blue-cable.de>)
Ответы Re: notify duplicate elimination performance  (Hardy Falk <hardy.falk@blue-cable.de>)
Список pgsql-hackers
Hardy Falk <hardy.falk@blue-cable.de> writes:
>> Well, you didn't add any code, so it's hard to say... Simple ways of
>> doing what I think you describe will remove the queue's order. Do you
>> preserve the ordering guarantees?

> Yes, the order is preserved.
> I didn't remove the the original list code.
> The tree is just an additional access path.

It seems likely that this approach would be a net loss for small numbers
of notify events (which is surely the common case).  Have you done any
measurements of the performance tradeoff?
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: notify duplicate elimination performance
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Changeset Extraction v7.5