In the past I found this tip to be helpful: https://wiki.postgresql.org/wiki/Loose_indexscan https://wiki.postgresql.org/wiki/Loose_indexscan. You can emulate i

In the past I found this tip to be helpful: https://wiki.postgresql.org/wiki/Loose_indexscan https://wiki.postgresql.org/wiki/Loose_indexscan. You can emulate it but it would be good for distinct to do this natively for default fast performance (distinct key queries) to avoid needing to know these tricks of the trade.