Optimize dropping of relation buffers during recovery

Edit

ID 2319

Title Optimize dropping of relation buffers during recovery

Topic Performance

Created 2019-10-28 08:16:52

Last modified 2021-01-14 02:48:28 (3 years, 10 months ago)

Latest email 2021-01-13 05:25:28 (3 years, 10 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 CFbot results (CirrusCI) CFbot GitHub

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

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