Postgres Pro
Downloads
Home   >   mailing lists

Re: sequential scan on select distinct - Mailing list pgsql-performance

From Ole Langbehn
Subject Re: sequential scan on select distinct
Date
Msg-id 200410071921.08685.ole@freiheit.com
Whole thread Raw
In response to Re: sequential scan on select distinct  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Responses Re: sequential scan on select distinct
List pgsql-performance
Tree view 
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.com technologies gmbh
Theodorstr. 42-90 / 22761 Hamburg, Germany
fon       +49 (0)40 / 890584-0
fax       +49 (0)40 / 890584-20

Freie Software durch Bücherkauf fördern | http://bookzilla.de/

pgsql-performance by date:

Previous
From: Gabriele Bartolini
Date:
Subject: Re: Data warehousing requirements
Next
From: Tom Lane
Date:
Subject: Re: sequential scan on select distinct