Re: PSQL performance - TPS

On Thu, Aug 1, 2019 at 2:15 PM Andres Freund <andres@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.