Am Donnerstag, 7. Oktober 2004 14:01 schrieb Pierre-Frédéric Caillaud:
> Side Note :
>
> What do you think about the idea of an "UniqueSort" which would do
> sort+unique in one pass ?
This is what oracle does and it is quite fast with it...
--
Ole Langbehn
freiheit
m 15 seconds to 14 milliseconds...
thanks for this very extensive answer, it helped me a lot.
>
> I don't know WHY (oh why) postgres does not use this kind of strategy
> when distinct'ing an indexed field... Anybody got an idea ?
That's the big question I still would like
nd' are standard indexes, so in case of
postgresql, it's a btree-index. I've tried to change the index type, but to no
avail.
So, why doesn't postgresql use the index, and (how) could i persuade postgresql
to use an index for this type of query?
TiA
--
Ole Langbehn
freihei