Re: Postgresql TPS Bottleneck

2022-04-20 Thread wakandavision
Clearly, I have only supplied half of the information there. I'm really sorry about that. The TPS measurement of the application does in no way correspond to the TPS of Postgres. They are measured completely different but it's the measure we actually are interested in - as we want to assess the

Re: Postgresql TPS Bottleneck

2022-04-20 Thread wakandavision
Hi, thanks for your answer. We have a Grafana instance monitoring all those metrics, no one I asked so far could identify an obvious bottleneck. However, I have done further experiments to see if we are missing something. While running the benchmark with our application I've run tools on the DB

Postgresql TPS Bottleneck

2022-03-31 Thread wakandavision
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