Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr

Поиск
Список
Период
Сортировка
От Dmitry Dolgov
Тема Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr
Дата
Msg-id CA+q6zcUMq6L96UuM4g0VKeoAnGLSSQexnSZ98nDYq-hJ2hc_EQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr
Список pgsql-hackers
Дерево обсуждения
> On 2 January 2018 at 20:52, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> I did find one case where the patch makes things significantly slower:
>
> select * from test where true is true
>  and true is true
>  and true is true
>  and true is true
>  ... (100 times altogether)

Yes, indeed, I never tested this kind of conditions. I can confirm, this query
is significantly slower with the previous version of the patch, but the current
version solves this.

> I'm disinclined to change the usage of "saop" here --- that's already
> in use in lots of code touching ScalarArrayOp

Oh, ok - I see now, thank you. So, I think no one would object if I'll mark
this patch as ready for committer.

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

Предыдущее
От: Amit Khandekar
Дата:
Сообщение: Re: [HACKERS] UPDATE of partition key
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: CFM for January commitfest?