Horton

Re: PSQL performance - TPS

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Purav Chovatia <puravc@gmail.com>
Cc: Shital A <brightuser2019@gmail.com>, pgsql-performance@lists.postgresql.org
Date: 2019-08-01T18:14:58Z
Lists: pgsql-performance 
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