Fix memory bloat caused by foreign key checking involving partitions

Title

Topic

Performance

Created

2021-01-08 06:48:33

Last modified

2021-03-10 19:23:08 (3 years, 1 month ago)

Latest email

2021-03-12 03:35:08 (3 years, 1 month 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

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