Postgres Pro
Downloads
Home   >   mailing lists

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

From Grzegorz Jaśkiewicz
Subject Re: select distinct, index not used
Date
Msg-id 2f4958ff0904160827r32200bb1ub8d73227480a5de9@mail.gmail.com
Whole thread Raw
In response to select distinct, index not used  (Thomas Guettler <hv@tbz-pariv.de>)
List pgsql-general
Tree view 
wasn't that improved now in 8.4, and before that on 8.3 ?
still there are some funny things with distinct/group by .
for instance, try
select count(distinct foo) from bar; vs
select count(1) from (select distinct foo from bar) f;

:)

I am not sure it pg was able to use index for that in 8.2.

pgsql-general by date:

Previous
From: Thomas Guettler
Date:
Subject: select distinct, index not used
Next
From: Tom Lane
Date:
Subject: Re: select distinct, index not used