4 ms·
Why not both then? I mean three... 2 for each column, one multi-column.
by inshadows 5y ago
Why not both then? I mean three... 2 for each column, one multi-column.
- jimktrains2 5y agoStorage overhead and the overhead of keeping the index up to date. if you have a write-heavy workload or one where transactions can lock the index, that can cause throughput issues.
- aeyes 5y agoIf you have a multi-column index on (number_start, number_end) Postgres will use it even if you are only filtering on number_start. An additional single column index on number_start would be redundant.