On Tue, 11 Sep 2018 at 13:56, Arup Rakshit <ar(at)zeit(dot)io> wrote:
> I have define a simple B Tree index on column *country* for users table. I
> don’t understand why the order by column not using the index scan when
> using *distinct* keyword in the select clause. Can anyone explain what is
> happening here?
>
Bear in mind that index skip scans aren't yet implemented, which (unless
I've missed the point) seems to be what you're expecting to help here.
https://wiki.postgresql.org/wiki/Loose_indexscan
Geoff