Reducing memory usage of creating foreign key between partitioned tables

Title

Topic

Performance

Created

2019-10-30 18:24:55

Last modified

2020-09-12 21:28:35 (4 years, 2 months ago)

Latest email

2020-09-04 11:34:29 (4 years, 2 months ago)

Status

2020-09: Rejected

2020-07: Moved to next CF

2020-03: Moved to next CF

2020-01: Moved to next CF

2019-11: Moved to next CF

Target version

Authors

sho kato (kato-sho)

Reviewers

Committer

Links

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/2330
git checkout commitfest/cf/2330

Emails

Creating foreign key on partitioned table is too slow: First at 2019-10-23 05:59:01 by "kato-sho at fujitsu.com" <kato-sho at fujitsu.com>
Latest at 2020-09-04 11:34:29 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (v3-0001-build-partdesc-memcxt.patch) at 2020-08-21 02:20:33 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v3-0001-build-partdesc-memcxt.patch) at 2020-08-21 02:20:33 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-build-partdesc-memcxt.patch) at 2019-11-13 21:45:44 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-build-partdesc-memcxt.patch) at 2019-11-13 18:50:47 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (build-PartitionDesc-when-needed-PoC.patch) at 2019-11-01 08:37:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (memleak-fix.patch) at 2019-10-24 22:17:58 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2020-09-12 21:28:35	Tom Lane (tgl)	Closed in commitfest 2020-09 with status: Rejected
2020-09-12 21:28:27	Tom Lane (tgl)	Added tgl as reviewer
2020-08-06 07:45:41	sho kato (kato-sho)	New status: Ready for Committer
2020-08-02 20:19:54	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 15:31:01	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:51:39	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-29 06:40:01	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-28 02:25:33	Michael Paquier (michael-kun)	Changed topic to Performance
2019-11-11 08:39:17	Michael Paquier (michael-kun)	Changed authors to sho kato (kato-sho)
2019-10-30 18:24:55	Tomas Vondra (fuzzycz)	Attached mail thread OSAPR01MB374809E8DE169C8BF2B82CBD9F6B0@OSAPR01MB3748.jpnprd01.prod.outlook.com
2019-10-30 18:24:55	Tomas Vondra (fuzzycz)	Created patch record