Databases

Practical Databases articles from OpenStair Engineering.

Category archive

Diagram showing database tables, indexes, queries, and connection flow

PostgreSQL Indexing: Practical Strategies for Real Applications

November 3, 2025 · 18 min read

A production guide to PostgreSQL indexing: access methods (B-tree, GIN, BRIN), query execution diagnostics, partial and covering indexes, HOT updates, and zero-downtime maintenance.

PostgreSQLDatabasesSQLBackend

Databases

Database Indexes Explained: How They Actually Improve Queries

November 2, 2025 · 19 min read

A deep dive into database indexes: storage pages, B+Tree anatomy, composite selectivity, covering indexes, write amplification, and query execution plan analysis.

DatabasesSQLBackendSoftware Engineering