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

Edit
Title mitigate O(n^2) behavior of WAL archiver process
Topic Performance
Created 2021-08-25 04:04:22
Last modified 2021-08-25 04:06:26 (4 weeks, 1 day ago)
Latest email 2021-09-21 17:24:44 (1 day, 11 hours ago)
Status
2021-09: Needs review
Target version 15
Authors Dipesh Pandit (dpandit)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer Robert Haas (rhaas)
Links
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-09-21 17:24:44 by Robert Haas <robertmhaas at gmail.com>
Latest 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>
    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-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