Re: PSQL performance - TPS
Rick Otten <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAMAYy4JwYX3v2D-w1HOY0YySvvmV5+y+V6K_7-zCFey2irxCAw@mail.gmail.com> |
On Thu, Aug 1, 2019 at 2:15 PM Andres Freund <[email protected]> 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.