Optimizing SELECT expr INTO var in plpgsql

Edit
ID 6447
Title Optimizing SELECT expr INTO var in plpgsql
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 (14 hours ago)
Latest email 2026-03-21 05:10:52 (7 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
Target version
Authors Tom Lane (tgl)
Reviewers Become reviewer
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
Edit