pgsql: Re-add item with better description: > * Allow ORDER BY ...

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Re-add item with better description: > * Allow ORDER BY ...
Date: 2005-04-25 13:03:37
Message-ID: 20050425130337.F0A755367D@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Re-add item with better description:

> * Allow ORDER BY ... LIMIT 1 to select high/low value without sort or
> index using a sequential scan for highest/lowest values
>
> Right now, if no index exists, ORDER BY ... LIMIT 1 requires we sort
> all values to return the high/low value. Instead The idea is to do a
> sequential scan to find the high/low value, thus avoiding the sort.
>

Modified Files:
--------------
pgsql/doc:
TODO (r1.1515 -> r1.1516)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1515&r2=1.1516)
pgsql/doc/src/FAQ:
TODO.html (r1.22 -> r1.23)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.22&r2=1.23)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2005-04-25 13:05:47 Re: pgsql: Remove item, not sure what it refers to:
Previous Message Tom Lane 2005-04-25 07:00:32 pgsql: Fix btree_gist to handle timetz zone correctly per recent