Hi Bruce,
Based on pg_test_fsync results, should we choose open_datasync or fdatasync
as wal_sync_method? Can we rely on pg_test_fsync for choosing the best
wal_sync_method or is there any other way?
Thanks and Regards,
Nikhil
On Mon, Jun 29, 2020 at 9:36 PM Bruce Momjian wrote:
> On Mon, Jun
On Mon, Jun 29, 2020 at 02:56:42PM +0530, Nikhil Shetty wrote:
> Hi Team,
>
> We have a PostgreSQL 11.5.6 database running on VM.
> RAM - 48GB
> CPU - 6 cores
> Disk - SSD on SAN
>
> We wanted to check how the WAL disk is performing using pg_test_fsync.We ran a
> test and got around 870 ops/sec
Hi Team,
We have a PostgreSQL 11.5.6 database running on VM.
RAM - 48GB
CPU - 6 cores
Disk - SSD on SAN
We wanted to check how the WAL disk is performing using pg_test_fsync.We
ran a test and got around 870 ops/sec for opendatasync and fdatasync and
just 430 ops/sec for fsync.We feel it is quite
