From: gnuoytr@rcn.com
To: pgsql-performance@postgresql.org
Subject: Re: Useless sort by
Date: Wed, 22 Sep 2010 23:05:31 -0400 (EDT)
Message-ID: <20100922230531.ALE43726@ms14.lnh.mail.rcn.net> (raw)
In-Reply-To: <AANLkTi=VJXvNS_ysdNQOts2OiZVr-HfRgLS=qv25FoqE@mail.gmail.com>
References: <i6ks04$2jet$1@news.hub.org>
<12103.1284389088@sss.pgh.pa.us>
<4C8E4982.70004@gmail.com>
<14518.1284396487@sss.pgh.pa.us>
<AANLkTi=RqV1Q-zJW2+JP3PBaQb4mxPz9ZS9BL_fCsG3Y@mail.gmail.com>
<AANLkTi=VJXvNS_ysdNQOts2OiZVr-HfRgLS=qv25FoqE@mail.gmail.com>
---- Original message ----
>Date: Wed, 22 Sep 2010 20:54:22 -0400
>From: pgsql-performance-owner@postgresql.org (on behalf of Robert Haas <robertmhaas@gmail.com>)
>Subject: Re: [PERFORM] Useless sort by
>To: Gaetano Mendola <mendola@gmail.com>
>Cc: Tom Lane <tgl@sss.pgh.pa.us>,pgsql-performance@postgresql.org
>
>On Mon, Sep 13, 2010 at 1:09 PM, Gaetano Mendola <mendola@gmail.com> wrote:
>> I see your point, but some functions like: Â unique, 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 Enterprise Postgres Company
>
>--
>Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gnuoytr@rcn.com
Subject: Re: Useless sort by
In-Reply-To: <20100922230531.ALE43726@ms14.lnh.mail.rcn.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox