Loose index scan is made for this <a href="https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html#loose-index-scan" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/group-by-optimizatio...
Postgres doesn't have it yet <a href="https://wiki.postgresql.org/wiki/Loose_indexscan" rel="nofollow">https://wiki.postgresql.org/wiki/Loose_indexscan
nattaylor · · focus · HN ↗
Postgres doesn't have it yet <a href="https://wiki.postgresql.org/wiki/Loose_indexscan" rel="nofollow">https://wiki.postgresql.org/wiki/Loose_indexscan
[deleted] · · focus · HN ↗
[deleted]