Semab Tariq

In a previous blog post, we configured an EC2 instance and installed PostgreSQL on it. After the initial setup, we ran pgbench to measure the initial TPS (transactions per second). Then, we tuned PostgreSQL and reran pgbench to see how much we could improve the TPS. To tune PostgreSQL, we adjusted various parameters based on the system's available resources. In this blog, we will identify which of those parameters contributed the most to the performance improvements. We will use the same instance size on AWS EC2 as before, which is t2.large. Here is the list of parameters that we initially tuned...

Learn how to configure key parameters to boost Transactions Per Second (TPS) and improve overall database performance.

Learn about PostgreSQL partitioning, its types, and benefits for optimized database performance.

Learn how the combination of ORDER BY and LIMIT clauses in PostgreSQL affects query performance, and discover optimization techniques to maintain efficient database performance and fast query responses.