Database index

• Index (PostgreSQL)

• create index
• CREATE INDEX IF NOT EXISTS

Related

• Index
• FOREIGN KEY Constraint
• Index-Only Scans and Covering Indexes

News

• PostgreSQL 18 (Sep 2025) supports parallel builds for GIN indexes, joining B-tree and BRIN indexes in supporting this capability
• PostgreSQL 13: Parallelized vacuuming of indexes

See also

• Index (PostgreSQL): CREATE INDEX, Index Locking, INDEX, REINDEX TABLE
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DML, DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql, OpenSearch SQL, Transact-SQL