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
