StormaticsStormatics

Optimizing PostgreSQL with Composite and Partial Indexes: A Quick Comparison

Indexes are crucial for accelerating database queries, and enhancing the performance of your PostgreSQL applications. However, not all indexes function the same way. Composite and partial indexes are two common types, each with distinct purposes and effects on performance. In this blog, we'll dive into what composite and partial indexes are, how they operate, and when to use them to achieve the best results for your database.
Read More

A Beginner’s Guide to Sharding PostgreSQL with Citus

PostgreSQL is a powerful and open-source relational database system known for its reliability, flexibility, and advanced features. It handles complex queries, ensures data integrity, and can be extended to meet various needs, making it a popular choice for many applications. However, as your data grows and the number of transactions increases, scaling PostgreSQL can be challenging.
Read More

A Follow up on Key PostgreSQL Configuration Parameters for Enhanced Performance – Part 2

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...
Read More