Re: Rangejoin rebased

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Rangejoin rebased
Дата
Msg-id CANP8+j+QRbpFjBLezj_bOEeUU3f=sLegtbxM1DqP0s5W9MO0eQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Rangejoin rebased  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Rangejoin rebased
Список pgsql-hackers
Дерево обсуждения 
On 19 January 2018 at 08:25, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 17 January 2018 at 05:49, Jeff Davis <pgsql@j-davis.com> wrote:
>> On Wed, Jan 10, 2018 at 7:49 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>>> Do we optimize for TIMESTAMP <@ RANGE as well?
>>
>> Not currently. It requires a little extra complexity because empty
>> ranges will match anything and need special handling.

err... that isn't correct. An empty range matches nothing, so can be
ignored in joins.

So probably best to explain some more, please.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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