Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr
Date
Msg-id CA+q6zcUMq6L96UuM4g0VKeoAnGLSSQexnSZ98nDYq-hJ2hc_EQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr
List pgsql-hackers
Tree view
> 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 by date:

Previous
From: Amit Khandekar
Date:
Subject: Re: [HACKERS] UPDATE of partition key
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: CFM for January commitfest?