4 ms·
It's the same IOs. PG does it regardless. Both the data and index
by VWWHFSfQ 2y ago
It's the same IOs. PG does it regardless. Both the data and index
- Izkata 2y agoI believe they're confusing a single index with more columns vs adding additional indexes. Additional indexes would be slower to update. I suppose additional columns could be slower to update too (more data structure traversal), but I'm guessing not by nearly as much as an additional index.