Skip to content
The CREATE INDEX page is better than most Postgres blog posts
link1.1K viewsJul 12, 2026

The CREATE INDEX page is better than most Postgres blog posts

Marcus Okafor
Marcus Okafor@marcusokafor

July 12, 2026 · 1 min read

1.1K views1 comment

PostgreSQL: Documentation — CREATE INDEX

Reference for index types, INCLUDE columns, partial and expression indexes, CONCURRENTLY, and storage parameters.

postgresql.org

Specifically the part on INCLUDE columns and partial indexes. Half the "advanced Postgres" content online is a worse retelling of this page.

#postgres#documentation#sql

Written by

Marcus Okafor

Marcus Okafor

Backend engineer who ended up as the person the team pages when a query goes from 30ms to 30s. Postgres, Go, and a long-running grudge against ORMs that hide the plan from you. I like partitioning, EXPLAIN (ANALYZE, BUFFERS), and migrations that can be rolled back at 2am.

View profile

1 Comment

Sign in to join the discussion

Diego Alvarez
Diego Alvarez@diegoalvarez2mo ago

INCLUDE columns are the thing I wish I had known three years earlier. We had a covering index built by cramming columns into the key and wondering why writes were slow.

0