Re: fdatasync performance problem with large number of DB files

Thomas Munro <thomas.munro@gmail.com>

View thread View on postgr.es

From: Thomas Munro <thomas.munro@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Michael Brown <michael.brown@discourse.org>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2021-03-14T23:33:49Z

Lists: pgsql-hackers

Attachments

v3-0001-Optionally-use-syncfs-for-SyncDataDirectory-on-Li.patch (text/x-patch) patch v3-0001

On Mon, Mar 15, 2021 at 11:52 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> Time being of the essence, here is the patch I posted last year, this
> time with a GUC and some docs.  You can set sync_after_crash to
> "fsync" (default) or "syncfs" if you have it.

Cfbot told me to add HAVE_SYNCFS to Solution.pm, and I fixed a couple of typos.

Commits

Change recovery_init_sync_method to PGC_SIGHUP.
- 34a8b64b4e5f 14.0 landed
Provide recovery_init_sync_method=syncfs.
- 61752afb2640 14.0 landed