Umair's Planet PostgreSQL Archives - Page 5 of 6 - Stormatics

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

Distributed Data in PostgreSQL with postgres_fdw: A Guide to Enhanced Performance and Flexibility

postgres_fdw allows seamless access into external PostgreSQL databases as if it were local to your current database...

How Does Incremental Sort Work?

Incremental Sort in PostgreSQL: A Developer’s Guide

By following best practices and query optimization techniques, you can leverage incremental sort in PostgreSQL and enhance query performance.

MVCC (Multi-Version Concurrency Control) and its impact on UPDATE queries.

Improving UPDATE query performance using Heap-Only Tuples (HOT)

Heap-Only Tuples allow a significant boost in UPDATE query performance allowing businesses to scale their PostgreSQL for critical data.

A look at PostgreSQL’s journey over 5 years in Stack Overflow’s Developer Survey

A look at 5 year trends of database popularity, focusing on PostgreSQL, based on Stack Overflow's annual developer survey

Data inconsistency in highly available PostgreSQL clusters

If nodes in a database cluster get out of sync, the inconsistency can cause data corruption. This blog describes what to watch out for.

Disruptions caused by false alarms in highly available PostgreSQL clusters

False alarms can be a significant problem in highly available clusters of PostgreSQL. They can cause unnecessary downtime and disruptions that can impact the performance of the nodes.