On Wed, Jul 1, 2020 at 11:41:23PM +0530, Nikhil Shetty wrote:
> Hi,
>
> The client has done benchmark tests on available storage using a storage
> benchmark tool and got IOPS of around 14k on iSCSI and around 150k on HBA
> channel, which seems a good number but pg_test_fysnc gives numbers which are
> not reflecting good op/sec. Though pg_test_fysnc result should not be compared
> to benchmark throughput but both are indicative of overall database
> performance.
Well, by definition, pg_test_fsync asks for fsync after every set of
writes. Only the last report, "Non-sync'ed 8kB writes:" gives non-fsync
performance.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee