Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC

Title

CI (CFBot)

Needs rebase! Needs rebase since 1 week. Failing since 1 week.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Monitoring & Control

Created

2025-02-24 20:52:50

Last modified

2025-02-26 21:28:41 (1 month ago)

Latest email

2025-03-05 01:47:16 (3 weeks ago)

Status

2025-03: Needs review

Target version

Authors

James Hunter (hunjmes)

Reviewers

Become reviewer

Committer

Links

Emails

Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators

First at 2025-01-10 18:00:15 by James Hunter <james.hunter.pg at gmail.com>
Latest at 2025-03-05 01:47:16 by James Hunter <james.hunter.pg at gmail.com>
Latest attachment (0001-Store-working-memory-limit-per-Plan-SubPlan-rather-t.patch) at 2025-03-05 01:47:16 from James Hunter <james.hunter.pg at gmail.com>

    Attachment (0001-Store-working-memory-limit-per-Plan-SubPlan-rather-t.patch) at 2025-03-05 01:47:16 from James Hunter <james.hunter.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Store-non-init-plan-SubPlan-objects-in-Plan-list.patch) at 2025-02-26 21:27:17 from James Hunter <james.hunter.pg at gmail.com> (Patch: Yes)
    Attachment (v03_0001-EXPLAIN-now-takes-work_mem-option-to-display-estimat.patch) at 2025-02-24 22:07:35 from James Hunter <james.hunter.pg at gmail.com> (Patch: Yes)
    Attachment (v02_0001-EXPLAIN-now-takes-work_mem-option-to-display-estimat.patch) at 2025-02-24 21:46:49 from James Hunter <james.hunter.pg at gmail.com> (Patch: Yes)
    Attachment (v01_0001-EXPLAIN-now-takes-work_mem-option-to-display-estimat.patch) at 2025-02-24 20:46:23 from James Hunter <james.hunter.pg at gmail.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2025-02-24 21:50:02	James Hunter (hunjmes)	From James Hunter <james.hunter.pg@gmail.com> at 2025-02-24 21:46:49	latest patch
2025-02-24 22:10:21	James Hunter (hunjmes)	From James Hunter <james.hunter.pg@gmail.com> at 2025-02-24 22:07:35	latest patch
2025-02-26 21:28:41	James Hunter (hunjmes)	From James Hunter <james.hunter.pg@gmail.com> at 2025-02-26 21:27:17	latest patch

History

When	Who	What
2025-03-19 05:16:43	CFbot	Patch needs rebase
2025-03-05 02:02:44	CFbot	Patch does not need rebase anymore
2025-03-01 05:52:36	CFbot	Patch needs rebase
2025-02-26 21:28:41	James Hunter (hunjmes)	Added annotation "latest patch" to CAJVSvF6ckAvcFkCT-cWAqYpVn2MM5zOEiTT-ubBB4mjFfCkAWQ@mail.gmail.com
2025-02-24 22:10:21	James Hunter (hunjmes)	Added annotation "latest patch" to CAJVSvF4_Q7d+-UPTGsWTevf0K3YE0ktk7hryxFzF+mZgsRP4GA@mail.gmail.com
2025-02-24 21:51:30	James Hunter (hunjmes)	Attached mail thread CAJVSvF6s1LgXF6KB2Cz68sHzk+v+O_vmwEkaon=H8O9VcOr-tQ@mail.gmail.com
2025-02-24 21:51:19	James Hunter (hunjmes)	Detached mail thread CAJVSvF6s1LgXF6KB2Cz68sHzk+v+O_vmwEkaon=H8O9VcOr-tQ@mail.gmail.com
2025-02-24 21:50:02	James Hunter (hunjmes)	Added annotation "latest patch" to CAJVSvF63zkNJPgT=5SygMtP7dQ5ANFm0C0mhXvLr0Rh-ihtOjQ@mail.gmail.com
2025-02-24 20:55:37	James Hunter (hunjmes)	Changed name to Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC
2025-02-24 20:54:07	James Hunter (hunjmes)	Changed authors to James Hunter (hunjmes)
2025-02-24 20:54:07	James Hunter (hunjmes)	Changed targetversion to 18
2025-02-24 20:52:50	James Hunter (hunjmes)	Attached mail thread CAJVSvF6s1LgXF6KB2Cz68sHzk+v+O_vmwEkaon=H8O9VcOr-tQ@mail.gmail.com
2025-02-24 20:52:50	James Hunter (hunjmes)	Created patch record

Edit