Home Original page

Fix memory bloat caused by foreign key checking involving partitions

Edit

ID 2930
Title Fix memory bloat caused by foreign key checking involving partitions
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Performance
Created 2021-01-08 06:48:33
Last modified 2021-03-10 19:23:08 (5 years ago)
Latest email 2021-03-12 03:35:08 (5 years ago)
Status

2021-03 (2021-03-01 – 2021-03-31): 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

Edit