Date: Thu, 1 Aug 2019 11:14:58 -0700
From: Andres Freund <andres@anarazel.de>
To: Purav Chovatia <puravc@gmail.com>
Cc: Shital A <brightuser2019@gmail.com>,
	pgsql-performance@lists.postgresql.org
Subject: Re: PSQL performance - TPS
Message-ID: <20190801181458.52zcdeahsj3fpwup@alap3.anarazel.de>
References: 
 <CAMp7vw8hHwVs-99Pph4GwmVENYaa5HGVVaa8_ED=FPbdf42ovQ@mail.gmail.com>
 <20190801172128.ct3absxmogavdv6v@alap3.anarazel.de>
 <CADrzpjG-JpxHVBZDYB_qtZyxmOPu_H=J1oirmyCdzAqp+RMi5g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CADrzpjG-JpxHVBZDYB_qtZyxmOPu_H=J1oirmyCdzAqp+RMi5g@mail.gmail.com>
Precedence: bulk

Hi,

On 2019-08-01 23:36:33 +0530, Purav Chovatia wrote:
> > If you've set synchronous_commit = off, and you still get only 1200
> > transactions/sec, something else is off. Are you sure you set that?
> I am not very surprised with these results. However, what’s the disk type?
> That can matter quite a bit.

Why aren't you surprised? I can easily get 20k+ write transactions/sec
on my laptop, with synchronous_commit=off.  With appropriate
shared_buffers and other settings, the disk speed shouldn't matter that
much for in insertion mostly workload.

Greetings,

Andres Freund