Optimize dropping of relation buffers during recovery

Edit

Title

Topic

Performance

Created

2019-10-28 08:16:52

Last modified

2021-01-14 02:48:28 (3 years, 7 months ago)

Latest email

2021-01-13 05:25:28 (3 years, 7 months ago)

Status

2021-01: Committed

2020-11: Moved to next CF

2020-09: Moved to next CF

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

Kirk Jamison (kirkjamison)

Reviewers

Takayuki Tsunakawa (maumau), Haiying Tang (tanghy)Become reviewer

Committer

Amit Kapila (amitkapila)

Links

Emails

[Patch] Optimize dropping of relation buffers using dlist: First at 2019-10-28 08:13:19 by "k.jamison at fujitsu.com" <k.jamison at fujitsu.com>
Latest at 2021-01-13 05:25:28 by "k.jamison at fujitsu.com" <k.jamison at fujitsu.com>
Latest attachment (v39-0001-Optimize-DropRelFileNodeBuffers-for-recovery.patch) at 2021-01-06 13:13:03 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com>
    Attachment (v39-0001-Optimize-DropRelFileNodeBuffers-for-recovery.patch) at 2021-01-06 13:13:03 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v38-0001-Optimize-DropRelFileNodeBuffers-for-recovery.patch) at 2020-12-24 14:07:17 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v37-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-12-23 12:57:24 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v36-0001-Optimize-DropRelFileNodeBuffers-for-recovery.patch) at 2020-12-22 09:25:08 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-12-14 03:00:12 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v34-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-12-10 08:09:55 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v33-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-12-03 03:49:27 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v32-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-11-26 03:04:10 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v31-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-11-12 04:00:14 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v30-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-11-10 02:49:38 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v29-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-11-04 02:58:27 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v28-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-10-28 12:52:08 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v27-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-10-22 02:06:43 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v26-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-10-22 00:41:48 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v25-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-10-15 03:34:09 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v24-0001-Prevent-invalidating-blocks-in-smgrextend-during.patch) at 2020-10-12 09:38:12 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (0001-v1-Prevent-invalidating-blocks-in-smgrextend-during-recovery.patch) at 2020-10-08 09:37:48 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (0001-v1-Prevent-invalidating-blocks-in-smgrextend-during-recovery.patch) at 2020-10-08 09:13:48 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (0001-v1-Prevent-invalidating-blocks-in-smgrextend-during-recovery.patch) at 2020-10-08 02:07:06 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v21-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-10-05 01:29:07 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v20-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-10-01 12:55:34 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v19-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-10-01 01:55:10 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v18-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-09-29 04:04:16 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v17-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-09-28 08:57:36 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (resume.sh) at 2020-09-25 08:18:55 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: No)
    Attachment (v16-Optimize-DropRelFileNodeBuffers-during-recovery.patch) at 2020-09-24 08:47:06 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v15-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-23 07:57:33 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v14-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-17 13:06:33 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v13-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-15 11:11:26 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v12-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-15 01:40:30 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v11-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-07 08:03:05 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v10-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-02 03:48:55 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v9-Speedup-dropping-of-relation-buffers-during-recovery.patch) at 2020-09-01 13:02:28 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (run.sh) at 2020-08-06 21:33:34 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v8-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2020-06-17 06:14:35 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v7-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2020-03-25 06:24:32 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v6-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2020-02-04 09:57:26 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v5-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2019-12-13 10:18:46 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v4-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2019-11-28 03:18:59 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v3-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2019-11-12 10:49:49 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v2-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2019-11-05 09:58:22 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)
    Attachment (v1-Optimize-dropping-of-relation-buffers-using-dlist.patch) at 2019-10-28 08:13:19 from "k.jamison at fujitsu.com" <k.jamison at fujitsu.com> (Patch: Yes)

History

When	Who	What
2021-01-14 02:48:28	Takayuki Tsunakawa (maumau)	Closed in commitfest 2021-01 with status: Committed
2021-01-14 02:48:28	Takayuki Tsunakawa (maumau)	Changed committer to amitkapila
2020-12-10 04:39:09	Haiying Tang (tanghy)	Added tanghy as reviewer
2020-12-03 07:11:16	Takayuki Tsunakawa (maumau)	New status: Ready for Committer
2020-12-03 03:50:17	Kirk Jamison (kirkjamison)	New status: Needs review
2020-12-01 14:09:17	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2020-12-01 14:09:09	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 14:09:05	Anastasia Lubennikova (lubennikovaav)	New status: Needs review
2020-11-27 08:30:36	Alexander Korotkov (smagen)	New status: Waiting on Author
2020-11-12 04:14:27	Takayuki Tsunakawa (maumau)	New status: Ready for Committer
2020-10-07 02:11:21	Takayuki Tsunakawa (maumau)	Added maumau as reviewer
2020-10-01 04:29:51	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-15 01:42:52	Kirk Jamison (kirkjamison)	New status: Needs review
2020-09-15 01:42:30	Kirk Jamison (kirkjamison)	Changed name to Optimize dropping of relation buffers during recovery
2020-09-07 08:06:01	Kirk Jamison (kirkjamison)	Changed name to Optimize dropping of relation buffers
2020-08-13 05:43:26	Takayuki Tsunakawa (maumau)	New status: Waiting on Author
2020-08-02 20:57:48	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-07-30 17:37:10	Konstantin Knizhnik (knizhnik)	Posted review with messageid <159613063066.781.12793786063691200490.pgcf@coridan.postgresql.org>
2020-07-30 17:37:10	Konstantin Knizhnik (knizhnik)	New status: Ready for Committer
2020-04-08 16:07:55	David Steele (dsteele)	Changed targetversion to None
2020-04-08 15:30:51	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:51:35	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-28 04:06:27	Kirk Jamison (kirkjamison)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-10-28 08:17:24	Kirk Jamison (kirkjamison)	Changed targetversion to 13
2019-10-28 08:17:24	Kirk Jamison (kirkjamison)	Changed authors to Kirk Jamison (kirkjamison)
2019-10-28 08:16:52	Kirk Jamison (kirkjamison)	Attached mail thread OSBPR01MB3207DCA7EC725FDD661B3EDAEF660@OSBPR01MB3207.jpnprd01.prod.outlook.com
2019-10-28 08:16:52	Kirk Jamison (kirkjamison)	Created patch record

Edit