2 ms·
I used your example to show how the 2 indexes solution is better on PostgreSQL, but the one composite index is the best one for YugabyteDB (PostgreSQL on a Span
by franckpachot 3y ago
I used your example to show how the 2 indexes solution is better on PostgreSQL, but the one composite index is the best one for YugabyteDB (PostgreSQL on a Spanner-like architecture): https://dev.to/yugabyte/one-fat-index-or-two-indexes-on-each-columns-postgresql-vs-yugabytedb-ngj https://dev.to/yugabyte/one-fat-index-or-two-indexes-on-each...
- hot_gril 3y agoYeah, I rarely use composite indexes in Postgres. Only if I want to squeeze a little more performance out of a frequent combo query.