Re: PSQL performance - TPS

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