Fix memory bloat caused by foreign key checking involving partitions

Edit
Title Fix memory bloat caused by foreign key checking involving partitions
Topic Performance
Created 2021-01-08 06:48:33
Last modified 2021-01-08 06:48:47 (2 weeks, 1 day ago)
Latest email 2021-01-12 00:48:59 (1 week, 4 days ago)
Status
2021-03: Needs review
Target version
Authors Amit Langote (amitlan), keisuke kuroda (keisuke.kuroda.3862)
Reviewers Become reviewer
Committer
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-01-12 00:48:59 by Keisuke Kuroda <keisuke.kuroda.3862 at gmail.com>
Latest 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>
    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-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