X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 836D4329E63 for ; Thu, 7 Oct 2004 18:19:30 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38820-09 for ; Thu, 7 Oct 2004 17:19:20 +0000 (GMT) Received: from mail.hamburg.cityline.net (jewel.mcs-hh.de [194.77.146.129]) by svr1.postgresql.org (Postfix) with ESMTP id 469B1329D41 for ; Thu, 7 Oct 2004 18:19:20 +0100 (BST) Received: from [212.1.56.10] (helo=aconitin.toxine.lan) by mail.hamburg.cityline.net with asmtp (TLSv1:RC4-MD5:128) (Exim 4.32) id 1CFbvC-0006e4-0w; Thu, 07 Oct 2004 19:19:18 +0200 From: Ole Langbehn Organization: freiheit.com To: =?iso-8859-15?q?Pierre-Fr=E9d=E9ric_Caillaud?= Subject: Re: sequential scan on select distinct Date: Thu, 7 Oct 2004 19:21:08 +0200 User-Agent: KMail/1.7 Cc: pgsql-performance@postgresql.org References: <200410061130.58625.ole@freiheit.com> <29194.1097091506@sss.pgh.pa.us> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200410071921.08685.ole@freiheit.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/85 X-Sequence-Number: 8561 Am Donnerstag, 7. Oktober 2004 14:01 schrieb Pierre-Fr=E9d=E9ric Caillaud: > Side Note : > > What do you think about the idea of an "UniqueSort" which would do > sort+unique in one pass ?=20 This is what oracle does and it is quite fast with it... --=20 Ole Langbehn freiheit.com technologies gmbh Theodorstr. 42-90 / 22761 Hamburg, Germany fon =A0 =A0 =A0 +49 (0)40 / 890584-0 fax =A0 =A0 =A0 +49 (0)40 / 890584-20 Freie Software durch B=FCcherkauf f=F6rdern | http://bookzilla.de/