4 ms·

This is a limitation which is currently being worked on. The order will still matter of course but it will allow PostgreSQL to make some use of indexes even whe

• johnthuss 2y ago
  >>> This is feasible in cases where the total number of distinct values in the column 'a' is reasonably small (think tens or hundreds, perhaps even thousands for very large composite indexes). It's great this is improving, but this is a fairly narrow improvement. Personally, the multi-column indexes I use would not be improved by this change since column 'a' does not store a "reasonably small" distribution of values.