pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / C

• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

CREATE INDEX

CREATE INDEX is a DDL command for creating an index.

CREATE INDEX has always been present in PostgreSQL.

Change history

• PostgreSQL 13
  • support for opclass parameters added (commit 911e7020)
  • implicit support for deprecated pre-PostgreSQL 8.0 opclass names removed (commit 84eca14b)
  • deduplicate_items storage parameter added (commit 0d861bbb)
• PostgreSQL 12
  • progress of CREATE INDEX can be tracked with pg_stat_progress_create_index (commit ab0dfc96)
• PostgreSQL 11
  • support for covering indexes via the INCLUDE clause added (commit 8224de4f)
• PostgreSQL 9.5
  • IF NOT EXISTS syntax added (commit 08309aaf)
• PostgreSQL 9.1
  • option COLLATE added (commit 414c5a2e)
• PostgreSQL 8.3
  • options ASC / DESC / NULLS FIRST / NULLS LAST (for btree indexes) added (commit 44317582)
• PostgreSQL 8.2
  • CREATE INDEX ... WITH (fillfactor = ...) syntax added (commit 277807bd)
  • CREATE INDEX CONCURRENTLY ... syntax added (commit e093dcdd)
• PostgreSQL 8.0
  • option TABLESPACE added (commit 2467394e)
• PostgreSQL 7.2
  • support for partial indexes added (initial commit f31dc0ad)
• PostgreSQL 6.1
  • proper multicolumn index creation (commit 65019fcf)

References

Categories

See also