Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0302E1337B50 for ; Thu, 23 Sep 2010 00:05:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 88219-05 for ; Thu, 23 Sep 2010 03:05:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp02.lnh.mail.rcn.net (smtp02.lnh.mail.rcn.net [207.172.157.102]) by mail.postgresql.org (Postfix) with ESMTP id 0B65D1337B3E for ; Thu, 23 Sep 2010 00:05:32 -0300 (ADT) Received: from ms14.lnh.mail.rcn.net ([208.58.56.82]) by smtp02.lnh.mail.rcn.net with ESMTP; 22 Sep 2010 23:05:31 -0400 Received: (from ms14.lnh.mail.rcn.net [69.182.178.117]) by ms14.lnh.mail.rcn.net (MOS 4.1.9-GA) with HTTP/1.1 id ALE43726 (AUTH gnuoytr@rcn.com); Wed, 22 Sep 2010 23:05:31 -0400 (EDT) From: Subject: Re: Useless sort by To: pgsql-performance@postgresql.org X-Mailer: Mirapoint Webmail Direct 4.1.9-GA MIME-Version: 1.0 In-Reply-To: References: <12103.1284389088@sss.pgh.pa.us> <4C8E4982.70004@gmail.com> <14518.1284396487@sss.pgh.pa.us> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-Id: <20100922230531.ALE43726@ms14.lnh.mail.rcn.net> Date: Wed, 22 Sep 2010 23:05:31 -0400 (EDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/147 X-Sequence-Number: 40350 ---- Original message ---- >Date: Wed, 22 Sep 2010 20:54:22 -0400 = >From: pgsql-performance-owner@postgresql.org (on behalf of Robert Haas = ) >Subject: Re: [PERFORM] Useless sort by = >To: Gaetano Mendola >Cc: Tom Lane ,pgsql-performance@postgresql.org > >On Mon, Sep 13, 2010 at 1:09 P= M, Gaetano Mendola wrote: >> I see your point, but = some functions like: =A0unique, count are not affected >> by the order = of values fed, and I don't think either that unique has to >> give out = the unique values in the same fed order. > >Gee, I'd sure expect it to= . Spoken like a dyed in the wool COBOL coder. The RM has no need for= order; it's set based. I've dabbled in PG for some time, and my sense = is increasingly that PG developers are truly code oriented, not database= (set) oriented. = robert > >-- = >Robert Haas >EnterpriseDB: http://www.enterprisedb.com >The Enterpris= e Postgres Company > >-- = >Sent via pgsql-performance mailing list (pgsql-performance@postgresql.o= rg) >To make changes to your subscription: >http://www.postgresql.org/= mailpref/pgsql-performance