pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Nikhil Shetty <nikhil.dba04@gmail.com>
Cc: Haroldo Kerry <hkerry@callix.com.br>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Subject: Re: Recommended value for pg_test_fsync
Date: Wed, 1 Jul 2020 15:59:58 -0400
Message-ID: <20200701195958.GA14460@momjian.us> (raw)
In-Reply-To: <CAFpL5VwvriA5i79DtwxF3VC98N=-hJ=qn3m=+Ry4-jaTLa=vVQ@mail.gmail.com>
References: <CAFpL5Vx8KQ4sdH5Bp=nq-uLwsr7N2rHiD+osMaMRzmRADqFVtA@mail.gmail.com>
	<CAMkU=1yY7PkZx1cDKEVAw1C24LYAr-zTqF0VVk3TX3miy59eng@mail.gmail.com>
	<CAFpL5VxAXdDLqbB=XUT1yo=NZX7vtGpUZa80W78w=AE_5F2iJQ@mail.gmail.com>
	<CAHxH9rNBzgZ75Vxe1D0ry7XJu2rW1hCULy1XFzBZWGE5CtMSJQ@mail.gmail.com>
	<CAFpL5Vwz9PbeaKwM2b757izr+-OuVu=G1wGPR2bt=E6uAW9VAQ@mail.gmail.com>
	<CAFpL5VwvriA5i79DtwxF3VC98N=-hJ=qn3m=+Ry4-jaTLa=vVQ@mail.gmail.com>

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






view thread (13+ messages)

Message-ID: <20200701195958.GA14460@momjian.us>
Permalink:  ../20200701195958.GA14460@momjian.us/
Also on:    postgresql.org/message-id/20200701195958.GA14460@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bruce@momjian.us, nikhil.dba04@gmail.com, hkerry@callix.com.br, jeff.janes@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Recommended value for pg_test_fsync
  In-Reply-To: <20200701195958.GA14460@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox