Add the ability to limit the amount of memory that can be allocated to backends.

Edit
ID 3867
Title Add the ability to limit the amount of memory that can be allocated to backends.
Topic Server Features
Created 2022-08-31 16:54:47
Last modified 2024-08-01 01:53:33 (2 months ago)
Latest email 2024-03-15 07:00:00 (6 months, 3 weeks ago)
Status
2024-09: Waiting on Author
2024-07: Moved to next CF
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
Target version
Authors Reid Thompson (jreidthompsoncd), John Morris (coyotebush)
Reviewers Become reviewer
Committer
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/3867
git checkout commitfest/cf/3867
Emails
Add tracking of backend memory allocated to pg_stat_activity
First at 2022-08-31 16:03:06 by Reid Thompson <reid.thompson at crunchydata.com>
Latest at 2023-09-02 15:13:00 by Ted Yu <yuzhihong at gmail.com>
Latest attachment (memtrack-v4.patch) at 2023-08-31 16:18:57 from John Morris <john.morris at crunchydata.com>
    Attachment (memtrack-v4.patch) at 2023-08-31 16:18:57 from John Morris <john.morris at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-12-08 14:09:29 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-11-27 05:32:19 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-11-27 03:10:06 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-11-04 12:56:13 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-10-25 18:59:17 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-09-04 03:34:20 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (001-pg-stat-activity-backend-memory-allocated.patch) at 2022-08-31 16:03:06 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
Add the ability to limit the amount of memory that can be allocated to backends.
First at 2022-08-31 16:50:19 by Reid Thompson <reid.thompson at crunchydata.com>
Latest at 2024-03-15 07:00:00 by Alexander Lakhin <exclusion at gmail.com>
Latest attachment (v20240314-0001-Add-tracking-of-backend-memory-allocated.patch) at 2024-03-14 20:36:12 from "Anton A. Melnikov" <a.melnikov at postgrespro.ru>
    Attachment (v20240314-0001-Add-tracking-of-backend-memory-allocated.patch) at 2024-03-14 20:36:12 from "Anton A. Melnikov" <a.melnikov at postgrespro.ru> (Patch: Yes)
    Attachment (v20140313-0001-Add-tracking-of-backend-memory-allocated.patch) at 2024-03-13 07:41:45 from "Anton A. Melnikov" <a.melnikov at postgrespro.ru> (Patch: Yes)
    Attachment (results-count.pdf) at 2024-01-28 19:11:56 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (read-only.png) at 2024-01-23 11:47:18 from "Anton A. Melnikov" <a.melnikov at postgrespro.ru> (Patch: No)
    Attachment (v20231226-0001-Add-tracking-of-backend-memory-allocated.patch) at 2023-12-26 21:52:06 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (graph.png) at 2023-12-26 10:49:00 from "Anton A. Melnikov" <a.melnikov at postgrespro.ru> (Patch: No)
    Attachment (reorder_operators.diff) at 2023-10-03 11:33:37 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated.patch) at 2023-05-22 15:59:56 from reid.thompson at crunchydata.com (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2023-04-06 22:35:38 from reid.thompson at crunchydata.com (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2023-03-24 16:19:10 from reid.thompson at crunchydata.com (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2023-03-02 19:41:26 from reid.thompson at crunchydata.com (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2023-01-23 15:48:38 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2023-01-05 18:44:20 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2022-12-09 15:05:45 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2022-11-27 03:22:15 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2022-11-03 15:48:50 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-10-25 15:49:03 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-09-15 14:58:19 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0001-Add-tracking-of-backend-memory-allocated-to-pg_stat_.patch) at 2022-09-12 16:25:25 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (0002-Add-the-ability-to-limit-the-amount-of-memory-that-c.patch) at 2022-09-04 03:40:03 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
    Attachment (001-dev-max-memory.patch) at 2022-08-31 16:50:19 from Reid Thompson <reid.thompson at crunchydata.com> (Patch: Yes)
Re: Add the ability to limit the amount of memory that can be allocated to backends.
First at 2023-10-31 17:11:26 by John Morris <john.morris at crunchydata.com>
Latest at 2023-11-10 09:55:27 by jian he <jian.universality at gmail.com>
Latest attachment (memtrack_v5_adds_memory_tracking_to_postgres.patch) at 2023-10-31 17:11:26 from John Morris <john.morris at crunchydata.com>
    Attachment (memtrack_v5_adds_memory_tracking_to_postgres.patch) at 2023-10-31 17:11:26 from John Morris <john.morris at crunchydata.com> (Patch: No)
History
When Who What
2024-08-01 01:53:33 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-08 07:58:24 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-03-12 13:28:02 Aleksander Alekseev (a.alekseev) New status: Waiting on Author
2024-02-01 15:27:51 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-02-01 15:27:45 vigneshwaran C (vignesh.postgres) New status: Needs review
2023-12-04 10:03:54 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-10 10:33:44 John Naylor (john.naylor) New status: Waiting on Author
2023-11-01 19:16:18 Stephen Frost (sfrost) Attached mail thread BYAPR13MB26776A35AB57940680D4CE0EA0A0A@BYAPR13MB2677.namprd13.prod.outlook.com
2023-10-26 17:24:43 Stephen Frost (sfrost) Attached mail thread 67bb5c15c0489cb499723b0340f16e10c22485ec.camel@crunchydata.com
2023-10-26 17:23:46 Stephen Frost (sfrost) Changed authors to Reid Thompson (jreidthompsoncd), John Morris (coyotebush)
2023-10-02 09:58:39 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-02 19:26:00 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-09 02:39:20 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-02 20:01:22 Reid Thompson (jreidthompson) New status: Needs review
2023-02-14 00:26:34 Andres Freund (andresfreund) New status: Waiting on Author
2023-01-31 16:22:36 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-05 19:01:13 Reid Thompson (jreidthompson) New status: Needs review
2023-01-05 13:39:53 Arne Roland (harks) New status: Waiting on Author
2022-12-21 16:37:54 Reid Thompson (jreidthompson) New status: Needs review
2022-12-08 14:18:18 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-07 18:26:55 Andres Freund (andresfreund) New status: Waiting on Author
2022-10-25 16:41:38 Justin Pryzby (justinpryzby) New status: Needs review
2022-10-12 07:40:58 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 07:40:56 Michael Paquier (michael-kun) New status: Waiting on Author
2022-09-17 04:36:35 Justin Pryzby (justinpryzby) New status: Needs review
2022-09-15 08:07:39 Ibrar Ahmed (ibrar) New status: Waiting on Author
2022-09-08 21:57:36 Reid Thompson (jreidthompsoncd) Changed name to Add the ability to limit the amount of memory that can be allocated to backends.
2022-09-08 21:40:02 Reid Thompson (jreidthompson) Changed authors to Reid Thompson (jreidthompsoncd)
2022-09-07 17:26:40 Reid Thompson (jreidthompson) Changed authors to Reid Thompson (jreidthompson)
2022-09-07 16:50:47 Reid Thompson (jreidthompson) Changed authors to Reid Thompson (jreidthompsoncd)
2022-08-31 16:56:53 Reid Thompson (jreidthompson) Changed name to Add the ability to limit the amount of memory that can be allocated to backends. Requires Message-ID 67bb5c15c0489cb499723b0340f16e10c22485ec.camel@crunchydata.com
2022-08-31 16:54:47 Reid Thompson (jreidthompson) Attached mail thread bd57d9a4c219cc1392665fd5fba61dde8027b3da.camel@crunchydata.com
2022-08-31 16:54:47 Reid Thompson (jreidthompson) Created patch record
Edit