Re: Need to increase performance of a query - Mailing list pgsql-performance

From Jochen Erwied
Subject Re: Need to increase performance of a query
Date
Msg-id 98414706.20100610212211@erwied.eu
Whole thread Raw
In response to Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
Thursday, June 10, 2010, 8:36:08 PM you wrote:

> psrdb=# (SELECT
> psrdb(#        MAX(item_rank.rank) AS maxRank
> psrdb(# FROM
> psrdb(#        item_rank item_rank
> psrdb(# WHERE
> psrdb(#        item_rank.project_id='proj2783'
> psrdb(#         AND item_rank.pf_id IS NULL
> psrdb(#
> psrdb(# )
> psrdb-# ORDER BY
> psrdb-# maxRank DESC;

Don't think it does really matter, but why do you sort a resultset
consisting of only one row?

--
Jochen Erwied     |   home: jochen@erwied.eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@mbs-software.de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@vodafone.de       +49-173-5404164


pgsql-performance by date:

Previous
From: Jochen Erwied
Date:
Subject: Re: Need to increase performance of a query
Next
From: Anne Rosset
Date:
Subject: Re: Need to increase performance of a query