Blog Archives - Page 13 of 18 - Stormatics

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 […]

Understanding Hash aggregates and Hash Joins in PostgreSQL

Discover the reasons behind a planner's selection of Hash aggregate and Hash joins for data processing and understand their workings through this blog.

Logical Replication in PostgreSQL

Understand the components involved in logical replication, how it differentiates from streaming replication and the factors to consider.

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

AI Meets PostgreSQL – The pgvector Revolution in Text Search

Explore how pgvector works to find words with similar meanings, enhancing the intelligence of databases for a more advanced user experience.

Checkpoints, Background Writer and how to monitor it using pg_stat_bgwriter

Understand Checkpoints and how they differ from background writer in PostgreSQL. Learn how to monitor them using pg_stat_bgwriter view.

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

An Introduction to EDB’s Transparent Data Encryption

We take a detailed look at EDB’s solution and also provide a few notes about what has been proposed for community Postgres...

Understanding Triggers In PostgreSQL

Think of triggers as the silent guardians behind the scenes, ensuring data integrity, enforcing business rules, and automating repetitive tasks.