Replace IN VALUES with ANY in WHERE clauses during optimization

Title

Topic

Performance

Created

2024-10-07 19:08:07

Last modified

2024-10-07 19:09:29 (1 month, 1 week ago)

Latest email

2024-11-11 17:29:14 (1 week, 1 day ago)

Status

2024-11: Needs review

Target version

Authors

Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)

Reviewers

Committer

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5283
git checkout commitfest/cf/5283

Emails

Replace IN VALUES with ANY in WHERE clauses during optimization: First at 2024-10-03 19:52:48 by Ivan Kush <ivan.kush at tantorlabs.com>
Latest at 2024-11-11 17:29:14 by Ivan Kush <ivan.kush at tantorlabs.com>
Latest attachment (0001-Introduce-VALUES-ARRAY-transformation.patch) at 2024-10-04 09:05:01 from Andrei Lepikhov <lepihov at gmail.com>
Attachment (0001-Introduce-VALUES-ARRAY-transformation.patch) at 2024-10-04 09:05:01 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
Attachment (commands.sql) at 2024-10-03 19:52:48 from Ivan Kush <ivan.kush at tantorlabs.com> (Patch: No)

History

When	Who	What
2024-10-07 19:09:29	Alena Rybakina (alenka)	Changed authors to Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)
2024-10-07 19:09:28	Alena Rybakina (alenka)	Changed targetversion to 18
2024-10-07 19:08:07	Alena Rybakina (alenka)	Attached mail thread 0184212d-1248-4f1f-a42d-f5cb1c1976d2@tantorlabs.com
2024-10-07 19:08:07	Alena Rybakina (alenka)	Created patch record