public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alena Rybakina <[email protected]>
To: Tom Lane <[email protected]>
Cc: Peter Geoghegan <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: Alexander Korotkov <[email protected]>
Cc: Andrei Lepikhov <[email protected]>
Cc: Ivan Kush <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Laurenz Albe <[email protected]>
Subject: Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Date: Fri, 4 Apr 2025 19:30:47 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAPpHfdtO_vmpBtARWBsu6oXJKZMwy0YXjPbwqNqK=vOQ6qNG5A@mail.gmail.com>
<[email protected]>
<CAPpHfduXsnWzz7zOBcadug3iYMUN3HaQqw7uz7vo6EMdjPqAMg@mail.gmail.com>
<[email protected]>
<CAPpHfds-7eJ3ZMgyeVrMfC5E1nTHD4Bp0ch5MZhrYSoiCfERXw@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAPpHfdugRg1Nix_82AsUQOcz6Q-761_Y440t9zQLwdhy+YcC2Q@mail.gmail.com>
<[email protected]>
<CAPpHfduiD-0PnUDRa3woSm47+LNY48J4tcPspft2Rir2Ag+w2Q@mail.gmail.com>
<srnuqlttuimzmvoulhsrbgvj4vnul6b65osswvua7sfkqsvmuy@yg7apybpxp34>
<[email protected]>
<CAH2-WzmzBAtm4ujfNABpHZ9iLiG8=0j-GBUgtt9tNFqyw_BMAg@mail.gmail.com>
<[email protected]>
On 04.04.2025 19:00, Tom Lane wrote:
> Peter Geoghegan<[email protected]> writes:
>> Is somebody going to commit this soon? Alexander?
> Done.
>
> I thought the point of the test case was to check VALUES folding
> on both sides of the join. I'm not sure why that's actually
> a useful expenditure of test cycles, but Alena's patch undid that
> without adjusting the comment claiming that's what it's doing.
> So I kept the shape of the test the same while substituting
> hopefully-stabler tables as she did.
Yes, that's right. Thank you.
> If it's still not stable I think the next step is to nuke both
> test queries, since I remain of the opinion that they're likely
> a waste of cycles.
>
>
Agree.
--
Regards,
Alena Rybakina
Postgres Professional
view thread (12+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Replace IN VALUES with ANY in WHERE clauses during optimization
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox