Index Access Method Changes
Compare the documented capability states and storage-option inventories of PostgreSQL releases.
Reading PostgreSQL 9.2.24.
Version comparison
GiST
Newly listed storage options: buffering.
SP-GiST
Recorded in PostgreSQL 9.2; absent from the 9.1 inventory.
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 9.2.24
| Capability | B-tree | Hash | GiST | SP-GiST | GIN |
|---|---|---|---|---|---|
| Sorted output | Yes | No | No | No | No |
| Unique keys | Yes | No | No | No | No |
| Multiple key columns | Yes | No | Yes | No | Yes |
| INCLUDE columns | No | No | No | No | No |
| Index-only scans | Not established | Not established | Not established | Not established | Not established |
| Distance ordering | Not established | Not established | Conditional | Not established | Not established |
| Parallel index scan | Not established | Not established | Not established | Not established | Not established |
| Parallel index build | Not established | Not established | Not established | Not established | Not established |