mitigate O(n^2) behavior of WAL archiver process

Edit
ID 3297
Title mitigate O(n^2) behavior of WAL archiver process
Topic Performance
Created 2021-08-25 04:04:22
Last modified 2021-11-11 21:05:38 (3 years, 1 month ago)
Latest email 2021-11-11 21:12:38 (3 years, 1 month ago)
Status
2021-11: Committed
2021-09: Moved to next CF
Target version 15
Authors Nathan Bossart (bossartn), Dipesh Pandit (dpandit)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer Robert Haas (rhaas)
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/3297
git checkout commitfest/cf/3297
Emails
.ready and .done files considered harmful
First at 2021-05-03 20:49:16 by Robert Haas <robertmhaas at gmail.com>
Latest at 2021-11-11 21:12:38 by Robert Haas <robertmhaas at gmail.com>
Latest attachment (v3-0001-Improve-performance-of-pgarch_readyXlog-with-many.patch) at 2021-09-27 18:03:33 from "Bossart, Nathan" <bossartn at amazon.com>
    Attachment (v3-0001-Improve-performance-of-pgarch_readyXlog-with-many.patch) at 2021-09-27 18:03:33 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v7-0001-Do-fewer-directory-scans-of-archive_status.patch) at 2021-09-20 22:49:09 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v6-0001-Do-fewer-directory-scans-of-archive_status.patch) at 2021-09-16 23:26:55 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v5-0001-keep-trying-the-next-file-approach.patch) at 2021-09-15 11:27:41 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v4-0001-keep-trying-the-next-file-approach.patch) at 2021-09-14 14:20:43 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v3-0001-keep-trying-the-next-file-approach.patch) at 2021-09-13 14:48:23 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v2-0001-keep-trying-the-next-file-approach.patch) at 2021-09-08 17:45:24 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v1-0001-keep-trying-the-next-file-approach.patch) at 2021-09-02 13:20:48 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (0001-keep-trying-the-next-file-approach.patch) at 2021-09-01 23:44:15 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v11-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-25 11:11:03 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v10-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-24 12:30:56 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Improve-performance-of-pgarch_readyXlog-with-many.patch) at 2021-08-22 04:28:51 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v9-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-19 12:39:53 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v8-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-18 11:05:23 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v7-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-17 12:52:42 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v6-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-12 11:52:12 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v5-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-08-02 13:06:00 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v4-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-07-27 07:43:00 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v3-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-07-22 07:16:07 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v2-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-07-19 12:12:56 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
    Attachment (v1-0001-mitigate-directory-scan-for-WAL-archiver.patch) at 2021-07-06 06:06:32 from Dipesh Pandit <dipesh.pandit at gmail.com> (Patch: Yes)
History
When Who What
2021-11-11 21:05:38 Nathan Bossart (bossartn) Closed in commitfest 2021-11 with status: Committed
2021-10-19 15:41:38 Nathan Bossart (bossartn) New status: Ready for Committer
2021-10-13 00:11:08 Nathan Bossart (bossartn) Changed authors to Nathan Bossart (bossartn), Dipesh Pandit (dpandit)
2021-10-04 07:24:24 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-25 04:06:26 Dipesh Pandit (dpandit) Changed reviewers to Nathan Bossart (bossartn)
2021-08-25 04:06:26 Dipesh Pandit (dpandit) Changed authors to Dipesh Pandit (dpandit)
2021-08-25 04:06:26 Dipesh Pandit (dpandit) Changed committer to rhaas
2021-08-25 04:06:26 Dipesh Pandit (dpandit) Changed targetversion to 15
2021-08-25 04:04:22 Dipesh Pandit (dpandit) Attached mail thread CA+TgmobhAbs2yabTuTRkJTq_kkC80-+jw=pfpypdOJ7+gAbQbw@mail.gmail.com
2021-08-25 04:04:22 Dipesh Pandit (dpandit) Created patch record
Edit