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, 8 months ago)
Latest email 2021-01-13 05:25:28 (3 years, 8 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