Hi Thomas,
Apologies for uploading the wrong screenshot in the attachment. I have
uploaded the correct output of pg_test_fsync for your reference .
Please find our environment details as below:
Infra: Azure IaaS
OS: Red Hat Enterprise Linux Server release 7.9
File System: XFS
Disk: Premium SSD
IO
On Mon, Dec 13, 2021 at 3:04 PM PGSQL DBA wrote:
> As you mentioned in question-8, "I'd investigate whether data is being cached
> unexpectedly, perhaps indicating that committed transactions be lost in a
> system crash event." So, I would like to know that if we configure the disk
> for the WA
On Fri, Dec 10, 2021 at 3:20 PM PGSQL DBA wrote:
> 1) How to interpret the output of pg_test_fsync?
The main interesting area is probably the top section that compares
the different wal_sync_method settings. For example, it's useful to
verify the claim that fdatasync() is faster than fsync() (be
