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

Edit

ID

Title

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

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2021-08-25 04:04:22

Last modified

2021-11-11 21:05:38 (3 years ago)

Latest email

2021-11-11 21:12:38 (3 years ago)

Status

2021-11 (2021-11-01 – 2021-11-30): Committed

2021-09 (2021-09-01 – 2021-09-30): Moved to different CF

Target version

15

Authors

Nathan Bossart (bossartn), 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-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