speed up pg_rewind by using copy_file_range() and skipping some fsync

Title

Topic

Performance

Created

2021-02-18 02:27:43

Last modified

2021-10-01 06:55:05 (3 years, 1 month ago)

Latest email

2021-08-20 05:23:07 (3 years, 3 months ago)

Status

2021-09: Returned with feedback

2021-07: Moved to next CF

2021-03: Moved to next CF

Target version

Authors

Paul Guo (paulguo-vmware)

Reviewers

Michael Paquier (michael-kun)Become reviewer

Committer

Links

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

Emails

Two patches to speed up pg_rewind.: First at 2021-01-27 09:18:48 by Paul Guo <guopa at vmware.com>
Latest at 2021-08-20 05:23:07 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v4-0001-Fsync-the-affected-files-directories-only-in-pg_r.patch) at 2021-08-05 10:18:03 from Paul Guo <paulguo at gmail.com>
    Attachment (v4-0001-Fsync-the-affected-files-directories-only-in-pg_r.patch) at 2021-08-05 10:18:03 from Paul Guo <paulguo at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Fsync-the-affected-files-directories-only-in-pg_r.patch) at 2021-05-28 05:30:51 from Paul Guo <guopa at vmware.com> (Patch: Yes)
    Attachment (v2-0001-Fsync-the-affected-files-directories-only-in-pg_r.patch) at 2021-02-19 02:33:13 from Paul Guo <guopa at vmware.com> (Patch: Yes)
    Attachment (0001-Fsync-the-affected-files-directories-only-in-pg_rewi.patch) at 2021-01-27 09:18:48 from Paul Guo <guopa at vmware.com> (Patch: Yes)

History

When	Who	What
2021-10-01 06:55:05	Michael Paquier (michael-kun)	Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-20 05:25:44	Michael Paquier (michael-kun)	Added michael-kun as reviewer
2021-08-17 07:48:02	Michael Paquier (michael-kun)	New status: Waiting on Author
2021-08-05 10:26:07	Paul Guo (paulguo-vmware)	New status: Needs review
2021-08-03 02:46:26	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-08-03 02:44:49	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:44:46	Masahiko Sawada (masahikosawada)	New status: Needs review
2021-06-17 07:20:41	Michael Paquier (michael-kun)	New status: Waiting on Author
2021-04-08 15:43:58	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-18 02:28:30	Paul Guo (paulguo-vmware)	Changed authors to Paul Guo (paulguo-vmware)
2021-02-18 02:27:43	Paul Guo (paulguo-vmware)	Attached mail thread 7C1703E7-F3F3-43FA-86EB-177C671BF33C@vmware.com
2021-02-18 02:27:43	Paul Guo (paulguo-vmware)	Created patch record