Re: [HACKERS] Index usage for elem-contained-by-const-range clauses

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Index usage for elem-contained-by-const-range clauses
Дата
Msg-id CA+TgmoYTh=7DEu1umHZpgacOJjxRt0rkci7q-EaGqwyCrfm31g@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Index usage for elem-contained-by-const-range clauses  (Pritam Baral <pritam@pritambaral.com>)
Список pgsql-hackers
On Thu, Feb 23, 2017 at 4:47 AM, Pritam Baral <pritam@pritambaral.com> wrote:
> The topic has been previously discussed[0] on the -performance mailing list,
> about four years ago.
>
> In that thread, Tom suggested[0] the planner could be made to "expand
> "intcol <@
> 'x,y'::int4range" into "intcol between x and y", using something similar
> to the
> index LIKE optimization (ie, the "special operator" stuff in indxpath.c)".
>
> This patch tries to do exactly that.

Please add your patch to https://commitfest.postgresql.org/ so it
doesn't get overlooked.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Performance degradation in TPC-H Q18