On Thu, Aug 1, 2019 at 2:15 PM Andres Freund <and...@anarazel.de> wrote:
> 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. > > Also a reminder that you should have a connection pooler in front of your database such as PGBouncer. If you are churning a lot of connections you could be hurting your throughput.