Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedPerformance & Indexes

Create Index Concurrently

SQL

CREATE INDEX CONCURRENTLY idx_orders_date 
ON orders (order_date);

Tested against PostgreSQL 16

Note

“Builds the index without locking the table against writes. Takes longer but is mandatory for production environments with zero downtime.