#postgresql

3 articles

PostgreSQL Index Tuning Guide — How to Reduce Slow Queries with EXPLAIN ANALYZE

PostgreSQL performance problems are not solved by creating more indexes blindly. This post explains how to read EXPLAIN ANALYZE, when Seq Scan is acceptable, how composite index ordering works, when partial indexes help, and how to tune sorting and pagination queries in practice.

April 19, 2026

What PostgreSQL 18.3's Out-of-Cycle Release Signals to Backend Teams

On February 26, 2026, the PostgreSQL project released PostgreSQL 18.3, 17.9, 16.13, and related patch versions as an out-of-cycle update. This post explains what backend teams should learn from that release.

April 19, 2026

MongoDB vs PostgreSQL — Which Database Should You Choose?

A practical comparison of MongoDB and PostgreSQL. Data models, performance, transactions, and operational costs — selection criteria from a real-world engineering perspective.

March 9, 2026