Re: [PERFORM] sequential scan on select distinct

2004-10-07 Thread Ole Langbehn
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

Re: [PERFORM] sequential scan on select distinct

2004-10-06 Thread Ole Langbehn
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

[PERFORM] sequential scan on select distinct

2004-10-06 Thread Ole Langbehn
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