Postgres Pro
Downloads
Home   >   mailing lists

Re: Why order by column not using index with distinct keyword inselect clause? - Mailing list pgsql-general

From Geoff Winkless
Subject Re: Why order by column not using index with distinct keyword inselect clause?
Date
Msg-id CAEzk6fdjd7SLk+OvHqTErMwTRs3QvdaUg+T6dY2TrK0zZG6w4A@mail.gmail.com
Whole thread Raw
In response to Why order by column not using index with distinct keyword in selectclause?  (Arup Rakshit <ar@zeit.io>)
List pgsql-general
Tree view
On Tue, 11 Sep 2018 at 13:56, Arup Rakshit <ar@zeit.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why order by column not using index with distinct keyword in select clause?
Next
From: Peter Eisentraut
Date:
Subject: Re: scram-sha-256 authentication broken in FIPS mode