Quick Links

Re: sequential scan on select distinct

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Ole Langbehn <ole(at)freiheit(dot)com>
Cc:	Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject:	Re: sequential scan on select distinct
Date:	2004-10-07 17:26:41
Message-ID:	199.1097170001@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Ole Langbehn <ole(at)freiheit(dot)com> writes:
>> 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...

Hashing is at least as fast, if not faster.

regards, tom lane

Re: sequential scan on select distinct at 2004-10-07 20:00:04 from Mischa Sandberg
Re: sequential scan on select distinct at 2004-10-08 09:57:13 from Pierre-Frédéric Caillaud

	From	Date	Subject
Next Message	Michael Adler	2004-10-07 18:15:38	Re: Excessive context switching on SMP Xeons
Previous Message	Ole Langbehn	2004-10-07 17:21:08	Re: sequential scan on select distinct