Index Access Method Changes
Compare the documented capability states and storage-option inventories of PostgreSQL releases.
Reading PostgreSQL 11.22.
Version comparison
B-tree
- INCLUDE columns: No → Yes
- Parallel index build: Not established → Yes (source coverage changed; no introduction date inferred)
Newly listed storage options: vacuum_cleanup_index_scale_factor.
Hash
- Parallel index build: Not established → No (source coverage changed; no introduction date inferred)
GiST
- Parallel index build: Not established → No (source coverage changed; no introduction date inferred)
SP-GiST
- Parallel index build: Not established → No (source coverage changed; no introduction date inferred)
GIN
- Parallel index build: Not established → No (source coverage changed; no introduction date inferred)
BRIN
- Parallel index build: Not established → No (source coverage changed; no introduction date inferred)
This comparison covers capability states and the names of documented storage options. It does not compare every algorithm, performance characteristic, option definition or release-note change.
Capabilities in PostgreSQL 11.22
| Capability | B-tree | Hash | GiST | SP-GiST | GIN | BRIN |
|---|---|---|---|---|---|---|
| Sorted output | Yes | No | No | No | No | No |
| Unique keys | Yes | No | No | No | No | No |
| Multiple key columns | Yes | No | Yes | No | Yes | Yes |
| INCLUDE columns | Yes | No | No | No | No | No |
| Index-only scans | Yes | No | Conditional | Conditional | No | No |
| Distance ordering | Not established | Not established | Conditional | Not established | Not established | Not established |
| Parallel index scan | Yes | No | No | No | No | No |
| Parallel index build | Yes | No | No | No | No | No |