Thread: pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

From
Thomas Munro
Date:
Default to wal_sync_method=fdatasync on FreeBSD.

FreeBSD 13 gained O_DSYNC, which would normally cause wal_sync_method to
choose open_datasync as its default value.  That may not be a good
choice for all systems, and performs worse than fdatasync in some
scenarios.  Let's preserve the existing default behavior for now.

Like commit 576477e73c4, which did the same for Linux, back-patch to all
supported releases.

Discussion: https://postgr.es/m/CA%2BhUKGLsAMXBQrCxCXoW-JsUYmdOL8ALYvaX%3DCrHqWxm-nWbGA%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f900a79ecdc1864a6ead72c97c34a41012227eaf

Modified Files
--------------
doc/src/sgml/config.sgml                      | 2 +-
src/backend/utils/misc/postgresql.conf.sample | 2 +-
src/include/port/freebsd.h                    | 9 +++++++++
3 files changed, 11 insertions(+), 2 deletions(-)