PostgreSQL: Documentation: 17: 11.8. Partial Indexes

11.8. Partial Indexes # A partial index is an index built over a subset of a table; the subset is defined …

PostgreSQL: Documentation: 18: 11.8. Partial Indexes July 16, 2026: PostgreSQL 19 Beta 2 Released! Documentation → PostgreSQL 18 Supported Versions: Current ( 18 ) / 17 / 16 / 15 / 14 Development Versions: 19 / devel Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 11.8. Partial Indexes Prev Up Chapter 11. Indexes Home Next 11.8. Partial Indexes # A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of the partial index). The index

related reading

• PostgreSQL: Documentation: 18: 11.4. Indexes and ORDER BYpostgresql.org
• Some indexing best practices - pgMustardpgmustard.com
• The startup's Postgres survival guidehatchet.run
• Partially ordered seten.wikipedia.org
• Build Your Own Databasenan.fyi
• Create an advanced search engine with PostgreSQL | xataxata.io
• you won't forget how postgres works after thisyoutube.com
• Blog — PlanetScaleplanetscale.com
• An in-depth look at Database Indexingfreecodecamp.org
• PostgreSQL: Documentation: 18: 54.1. Overviewpostgresql.org
• Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
• The only scalable delete in Postgres is DROP TABLE — PlanetScaleplanetscale.com