Fix memory bloat caused by foreign key checking involving partitions

2930

Title

Topic

Performance

Created

2021-01-08 06:48:33

Last modified

2021-03-10 19:23:08 (3 years, 8 months ago)

Latest email

2021-03-12 03:35:08 (3 years, 8 months ago)

Status

2021-03: Committed

Target version

Authors

Amit Langote (amitlan), keisuke kuroda (keisuke.kuroda.3862)

Reviewers

Amit Langote (amitlan)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/2930
git checkout commitfest/cf/2930

Emails

Huge memory consumption on partitioned table with FKs: First at 2020-11-24 07:46:28 by Tatsuro Yamada <tatsuro.yamada.tf at nttcom.co.jp>
Latest at 2021-03-12 03:35:08 by Tatsuro Yamada <tatsuro.yamada.tf at nttcom.co.jp>
Latest attachment (v5-0001-Share-SPI-plan-between-partitions-in-some-RI-trig.patch) at 2021-03-10 15:44:53 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v5-0001-Share-SPI-plan-between-partitions-in-some-RI-trig.patch) at 2021-03-10 15:44:53 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Share-SPI-plan-between-partitions-in-some-RI-trig.patch) at 2021-03-08 05:27:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-ri_triggers.c-Use-root-constraint-OID-as-key-to-r.patch) at 2020-12-04 06:32:32 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-separte-riinfo.patch) at 2020-12-04 03:05:22 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (0001-separte-riinfo.patch) at 2020-12-03 08:13:16 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v2-0001-ri_triggers.c-Use-root-constraint-OID-as-key-to-r.patch) at 2020-12-03 07:41:45 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2_reduce_ri_SPI-plan-hash.patch) at 2020-12-03 01:29:35 from Keisuke Kuroda <keisuke.kuroda.3862 at gmail.com> (Patch: Yes)
    Attachment (0001-ri_triggers.c-Use-root-constraint-OID-as-key-to-ri_q.patch) at 2020-12-02 13:02:50 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1_reduce_ri_SPI-plan-hash.patch) at 2020-11-26 00:59:28 from Keisuke Kuroda <keisuke.kuroda.3862 at gmail.com> (Patch: Yes)
    Attachment (repro.sql) at 2020-11-24 07:46:28 from Tatsuro Yamada <tatsuro.yamada.tf at nttcom.co.jp> (Patch: No)

History

When	Who	What
2021-03-10 19:23:08	Tom Lane (tgl)	Closed in commitfest 2021-03 with status: Committed
2021-03-09 23:18:57	Tom Lane (tgl)	Added tgl as committer
2021-03-03 13:58:14	Amit Langote (amitlan)	New status: Ready for Committer
2021-03-03 13:58:05	Amit Langote (amitlan)	Added amitlan as reviewer
2021-01-08 06:48:47	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan), keisuke kuroda (keisuke.kuroda.3862)
2021-01-08 06:48:33	Amit Langote (amitlan)	Attached mail thread cab4b85d-9292-967d-adf2-be0d803c3e23@nttcom.co.jp_1
2021-01-08 06:48:33	Amit Langote (amitlan)	Created patch record