pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def

pgsql: Default to wal_sync_method=fdatasync on FreeBSD.

2021-02-14 Thread Thomas Munro
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 def