Re: select distinct, index not used - Mailing list pgsql-general

Sam Mason <sam@samason.me.uk> writes:
> On Thu, Apr 16, 2009 at 11:29:25AM -0400, Tom Lane wrote:
>> , a full table indexscan isn't going to be particularly fast in
>> any case; it's often the case that seqscan-and-sort is the right
>> decision.

> Is PG capable of "skipping" over duplicate values using an index?

No, not at present.  It's on the TODO list.

            regards, tom lane