Re: Postgresql TPS Bottleneck

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