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
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
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()
Hi Team,
I would like to understand the internals of pg_test_fsync utility as I know
pg_test_fsync is intended to give us a reasonable idea of what is the
fastest wal_sync_method for our system but as per the documentation it will
also provide the diagnostic information in the event of an I/O