Optimizing SELECT expr INTO var in plpgsql

Edit
ID 6447
Title Optimizing SELECT expr INTO var in plpgsql
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Performance
Created 2026-02-01 05:33:11
Last modified 2026-02-01 05:33:12 (1 hour ago)
Latest email 2026-02-01 05:09:25 (2 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
Target version
Authors Tom Lane (tgl)
Reviewers Become reviewer
Committer
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-02-01 05:09:25 by Pavel Stehule <pavel.stehule at gmail.com>
Latest attachment (optimize-select-into-v1.patch) at 2026-01-31 20:58:34 from Tom Lane <tgl at sss.pgh.pa.us>
    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-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