PostgreSQL

0001-01-01

Reading EXPLAIN

EXPLAIN reveals the plan PostgreSQL chose without running the query. Reading cost, row estimates, and node type fluently is the starting point for all query analysis.

0001-01-01

Foreign Key Constraints and What the Planner Knows

A foreign key is not just validation — it is a declaration that tells the query planner something is guaranteed, enabling optimizations it cannot safely make without that guarantee.

0001-01-01

Query Rewriting and Anti-Patterns

Small SQL changes can have large performance effects. The most common slow queries share a recognizable EXPLAIN signature and a mechanical fix.

0001-01-01

Why Postgres?

PostgreSQL is not just storage — it is a concurrent data-access service. Here is what that means, and why the PostgreSQL project specifically is the right choice for any serious application.

0001-01-01

The Schema Decision AI Cannot Make

AI tools default to TEXT columns and application logic because they do not know what your database can express. Knowing PostgreSQL’s range types, exclusion constraints, and generated columns changes what you ask for — and what you get.