---- Original message ---- >Date: Wed, 22 Sep 2010 20:54:22 -0400 >From: pgsql-performance-owner@xxxxxxxxxxxxxx (on behalf of Robert Haas <robertmhaas@xxxxxxxxx>) >Subject: Re: Useless sort by >To: Gaetano Mendola <mendola@xxxxxxxxx> >Cc: Tom Lane <tgl@xxxxxxxxxxxxx>,pgsql-performance@xxxxxxxxxxxxxx > >On Mon, Sep 13, 2010 at 1:09 PM, Gaetano Mendola <mendola@xxxxxxxxx> 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@xxxxxxxxxxxxxx) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
