Optionally sync data directory with syncfs()

Title

Topic

Performance

Created

2021-03-14 23:08:49

Last modified

2021-03-19 23:17:08 (3 years, 8 months ago)

Latest email

2021-06-28 03:51:11 (3 years, 4 months ago)

Status

2021-07: Committed

Target version

Authors

Thomas Munro (macdice)

Reviewers

Committer

Thomas Munro (macdice)

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

Emails

fdatasync performance problem with large number of DB files: First at 2021-03-10 20:21:54 by Michael Brown <michael.brown at discourse.org>
Latest at 2021-06-28 03:51:11 by Thomas Munro <thomas.munro at gmail.com>
Latest attachment (v6-0001-Provide-recovery_init_sync_method-syncfs.patch) at 2021-03-19 05:28:46 from Thomas Munro <thomas.munro at gmail.com>
    Attachment (v6-0001-Provide-recovery_init_sync_method-syncfs.patch) at 2021-03-19 05:28:46 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Provide-recovery_init_sync_method-syncfs.patch) at 2021-03-19 01:37:11 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Provide-recovery_init_sync_method-syncfs.patch) at 2021-03-19 01:16:19 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optionally-use-syncfs-for-SyncDataDirectory-on-Li.patch) at 2021-03-18 10:19:13 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optionally-use-syncfs-for-SyncDataDirectory-on-Li.patch) at 2021-03-14 23:33:49 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Optionally-use-syncfs-for-SyncDataDirectory-on-Li.patch) at 2021-03-14 22:52:35 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)

History

When	Who	What
2021-03-19 23:17:08	Thomas Munro (macdice)	Closed in commitfest 2021-07 with status: Committed
2021-03-19 23:17:08	Thomas Munro (macdice)	Changed committer to macdice
2021-03-19 11:04:37	Justin Pryzby (justinpryzby)	New status: Ready for Committer
2021-03-14 23:08:56	Thomas Munro (macdice)	Changed authors to Thomas Munro (macdice)
2021-03-14 23:08:49	Thomas Munro (macdice)	Attached mail thread 11bc2bb7-ecb5-3ad0-b39f-df632734cd81@discourse.org
2021-03-14 23:08:49	Thomas Munro (macdice)	Created patch record