Re: Recommended value for pg_test_fsync

2020-07-01 Thread Bruce Momjian
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

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Nikhil Shetty
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

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Nikhil Shetty
Hi Haroldo, Thank you for the details. We are using xfs on IBM Power Linux Rhel7 but I will check this in our environment and get back to you with the results. Thanks and Regards, Nikhil On Wed, Jul 1, 2020, 22:46 Haroldo Kerry wrote: > Hello Nikhil, > We had performance issues with our Dell

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Haroldo Kerry
Hello Nikhil, We had performance issues with our Dell SC2020 storage in the past. We had a 6 SSD RAID10 setup and due all the latencies expected 20K IOPS but were getting 2K... After *a lot* of work the issue was not with the storage itself but with the I/O scheduler of the filesystem (EXT4/Debian

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Nikhil Shetty
Hi Jeff, To avoid confusion, Hitachi Storage G900 has 41Gbps Performance bandwidth (Throughput) and 10Gbps N/W bandwidth. Thanks and Regards, Nikhil On Wed, Jul 1, 2020 at 10:36 PM Nikhil Shetty wrote: > Hi Jeff, > > Thank you for your inputs. We may stick with fdatasync for now. We will > get

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Nikhil Shetty
Hi Jeff, Thank you for your inputs. We may stick with fdatasync for now. We will get more details on connection details between SAN and server from the storage team and update this thread. Storage is Hitachi G900 with 41Gbps bandwidth. Thanks and regards, Nikhil On Tue, Jun 30, 2020 at 9:51 P

Re: Recommended value for pg_test_fsync

2020-07-01 Thread Nikhil Shetty
Hi Bruce, Thank you. We may stick with fdatasync for now. Thanks and regards, Nikhil On Tue, Jun 30, 2020 at 8:54 PM Bruce Momjian wrote: > On Tue, Jun 30, 2020 at 10:32:13AM +0530, Nikhil Shetty wrote: > > Hi Bruce, > > > > Based on pg_test_fsync results, should we choose open_datasync or > f