From: Mladen Gogala <gogala.mladen@gmail.com>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql TPS Bottleneck
Date: Thu, 31 Mar 2022 22:40:25 -0400
Message-ID: <44e64451-73a0-b8de-4d88-25d642c62f6d@gmail.com> (raw)
In-Reply-To: <VI1PR04MB31338E811E0896D00D85B69B97E19@VI1PR04MB3133.eurprd04.prod.outlook.com>
References: <VI1PR04MB31338E811E0896D00D85B69B97E19@VI1PR04MB3133.eurprd04.prod.outlook.com>
On 3/31/22 07:50, wakandavision@outlook.com wrote:
> Hi everyone,
>
> I am a bachelor's student and writing my thesis about the scaling and
> performance of an application. The application is using postgresql as a
> database but we can't scale any further currently as it seems postgres
> is hitting the limit.
>
> With the application, as well as with pgbench, we don't get more than
> (max) 70k TPS on postgres. But the servers' resources are not utilized
> completely (more below).
I would try monitoring using "perf top" and "atop -d" to see what is
going on on the system. Also, try using sar to figure out what's going
on. Are you paging, waiting for I/O or having some other kind of
bottleneck. Once you figure where is your system spending time, you can
address the problem. In addition to that, analyze the log files with
pgbadger to find out which queries are time consuming and try optimizing
them.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gogala.mladen@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql TPS Bottleneck
In-Reply-To: <44e64451-73a0-b8de-4d88-25d642c62f6d@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox