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.

IntermediatePerformance & Indexes

Drop an Index

SQL

DROP INDEX CONCURRENTLY IF EXISTS idx_orders_date;

Tested against PostgreSQL 16

Note

“Drops the index. CONCURRENTLY prevents write locks during the drop process.