Re: Replace IN VALUES with ANY in WHERE clauses during optimization

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>
Cc: Andrei Lepikhov <lepihov(at)gmail(dot)com>, Ivan Kush <ivan(dot)kush(at)tantorlabs(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Subject: Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Date: 2025-04-03 15:26:48
Message-ID: CAPpHfduiD-0PnUDRa3woSm47+LNY48J4tcPspft2Rir2Ag+w2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 3, 2025 at 5:18 PM Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> wrote:
> Okay, I agree with you.

Good. I've reflected this limitation in comments and the commit
message. Also, I've adjust regression tests by removing excessive
ones and adding more important cases. I'm going to push this if no
objections.

------
Regards,
Alexander Korotkov
Supabase

Attachment Content-Type Size
v9-0001-Extract-make_SAOP_expr-function-from-match_orclau.patch application/octet-stream 7.3 KB
v9-0002-Convert-x-IN-VALUES-.-to-x-ANY-.-then-appropriate.patch application/octet-stream 24.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-04-03 15:29:49 Re: New criteria for autovacuum
Previous Message Fujii Masao 2025-04-03 15:21:27 Re: Extend ALTER DEFAULT PRIVILEGES for large objects