Menu

PostgreSQL Indexes

Browse PostgreSQL index creation, listing, types, multicolumn and expression indexes, partial and unique indexes, reindexing, and removal.

Indexes can make selective lookups faster, at the cost of storage and write work. Use these guides to create and inspect indexes, choose an index type, and maintain indexes:

For the matching metadata commands in MySQL, MariaDB, SQL Server, SQLite, and Oracle, see list indexes across SQL databases.

Advertisement

  1. PostgreSQL Index Types

    This article describes the types of indexes in PostgreSQL and how to use them properly.

  2. PostgreSQL CREATE INDEX

    Create PostgreSQL indexes with CREATE INDEX. Learn unique indexes, IF NOT EXISTS behavior, and concurrent builds that allow writes.

  3. PostgreSQL Drop Indexes

    This article describes how to drop existing indexes from a table usding DROP INDEX.

  4. PostgreSQL show indexes

    This article describes how to show indexes of a table in PostgreSQL.

  5. PostgreSQL Multicolumn Indexes

    This article describes how to create multicolumn indexes in PostgreSQL.

  6. PostgreSQL Unique Indexes

    Learn how PostgreSQL unique indexes enforce single-column and composite uniqueness, including NULLS NOT DISTINCT and partial indexes.

  7. PostgreSQL Expression Indexes

    This article describes how to create expression indexes in PostgreSQL.

  8. PostgreSQL Partial Indexes

    This article describes how to create partial indexes in PostgreSQL.

  9. PostgreSQL REINDEX

    This article describes how to rebuild indexes in PostgreSQL.