reduce memory requirements of PLpgSQL CALL statement

ID 2559

Title reduce memory requirements of PLpgSQL CALL statement

Topic Bug Fixes

Created 2020-05-18 16:35:41

Last modified 2020-09-29 15:19:13 (4 years, 1 month ago)

Latest email 2020-09-29 16:39:02 (4 years, 1 month ago)

Status

2020-09: Committed

2020-07: Moved to next CF

Target version

Authors Pavel Stehule (okbobcz)

Reviewers Tom Lane (tgl)Become reviewer

Committer Tom Lane (tgl)

Links CFbot results (CirrusCI) CFbot GitHub

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/2559
git checkout commitfest/cf/2559

Emails

calling procedures is slow and consumes extra much memory against calling function: First at 2020-05-10 20:20:53 by Pavel Stehule <pavel.stehule at gmail.com>
Latest at 2020-09-29 16:39:02 by Pavel Stehule <pavel.stehule at gmail.com>
Latest attachment (v2-plpgsql-stmt_call-fix-1.patch) at 2020-09-28 01:04:06 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v2-plpgsql-stmt_call-fix-1.patch) at 2020-09-28 01:04:06 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (plpgsql-stmt_call-fix-2.patch) at 2020-07-16 19:08:09 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (plpgsql-stmt_call_release_plan.patch) at 2020-07-11 05:38:21 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (plpgsql-call-fix-2.patch) at 2020-06-17 08:23:44 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (pl_exec_test.patch) at 2020-05-16 11:39:18 from Ranier Vilela <ranier.vf at gmail.com> (Patch: Yes)
    Attachment (plpgsql-call-fix.patch) at 2020-05-15 18:36:20 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (plpgsq-call-fix.patch) at 2020-05-11 05:25:20 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)

History

When	Who	What
2020-09-29 15:19:13	Tom Lane (tgl)	Closed in commitfest 2020-09 with status: Committed
2020-09-29 15:19:13	Tom Lane (tgl)	Changed committer to tgl
2020-09-28 00:34:43	Tom Lane (tgl)	Added tgl as reviewer
2020-09-17 09:02:30	Amit Khandekar (amitdkhan)	Changed reviewers to
2020-08-02 21:48:13	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-08-02 21:47:56	Daniel Gustafsson (d_gustafsson)	Changed name to reduce memory requirements of PLpgSQL CALL statement
2020-06-10 10:31:27	Amit Khandekar (amitdkhan)	Added amitdkhan as reviewer
2020-05-18 16:35:53	Pavel Stehule (okbobcz)	Changed authors to Pavel Stehule (okbobcz)
2020-05-18 16:35:41	Pavel Stehule (okbobcz)	Attached mail thread CAFj8pRDiiU1dqym+_P4_GuTWm76knJu7z9opWayBJTC0nQGUUA@mail.gmail.com
2020-05-18 16:35:41	Pavel Stehule (okbobcz)	Created patch record