11.9. Index-Only Scans and Covering Indexes # All indexes in PostgreSQL are secondary indexes, meaning that each index is stored separately …| PostgreSQL Documentation
11.8. Partial Indexes # A partial index is an index built over a subset of a table; the subset is defined …| PostgreSQL Documentation