Optimizing SELECT expr INTO var in plpgsql

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +71−9, All patches: +71−9

Tags

Performance

Created

2026-02-01 05:33:11

Last modified

2026-03-20 22:24:11 (2 weeks ago)

Latest email

2026-03-21 05:10:52 (2 weeks ago)

Status

PG19-Final (2026-03-01 – 2026-04-09): Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Committer

Tom Lane (tgl)

Links

Emails

slow SELECT expr INTO var in plpgsql: First at 2026-01-31 06:52:10 by Pavel Stehule <pavel.stehule at gmail.com>
Latest at 2026-03-21 05:10:52 by Pavel Stehule <pavel.stehule at gmail.com>
Latest attachment (optimize-select-into-v2.patch) at 2026-03-10 08:02:02 from Pavel Stehule <pavel.stehule at gmail.com>

Attachment (optimize-select-into-v2.patch) at 2026-03-10 08:02:02 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (0001-optimize-select-into-v2.patch) at 2026-03-10 07:58:59 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (optimize-select-into-v1.patch) at 2026-01-31 20:58:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2026-03-20 22:24:11	Tom Lane (tgl)	Closed in commitfest PG19-Final with status: Committed
2026-03-20 22:24:11	Tom Lane (tgl)	Changed committer to tgl
2026-02-01 05:33:12	Tom Lane (tgl)	Attached mail thread CAFj8pRDieSQOPDHD_svvR75875uRejS9cN87FoAC3iXMXS1saQ@mail.gmail.com
2026-02-01 05:33:11	Tom Lane (tgl)	Created patch record