Umair Shahid, Author at Stormatics - Page 5 of 8

Understanding the PostgreSQL Query Planner to Improve Query Performance

Learn how the PostgreSQL query planner estimates costs and leverages configuration parameters for efficient data retrieval and increased database performance.

The default value of fdw_tuple_cost was updated to 0.2. What does that mean?

This blog post explores the recent change to the fdw_tuple_cost parameter in PostgreSQL, examining the problem it addresses and the reasoning behind the new default value (0.2).

Enhancing PostgreSQL Performance by Scaling Horizontally using PL/Proxy

Discover how PL/Proxy enhances PostgreSQL performance through efficient horizontal scaling. Learn the pros, cons, and best practices for optimizing your database systems.

“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL

Unraveling the Mystery: Why PostgreSQL Costs You Nothing Each time I mention that PostgreSQL comes with zero licensing fees, I’m met with skeptical looks and a barrage of “Really? But how much does the license actually cost?”. It has happened enough times that I decided to write a blog explaining this, keeping in mind especially […]

The Next 20 Years of PostgreSQL: Embracing Better Persuasion

Simon Riggs, a luminary in the PostgreSQL community and a strategic advisor to Stormatics, recently addressed the future trajectory of PostgreSQL recently addressed a keynote at PGConf EU...