Postgres Pro
Downloads
Home   >   mailing lists

Re: Order by optimisations? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Order by optimisations?
Date
Msg-id 14216.1121347936@sss.pgh.pa.us
Whole thread Raw
In response to Re: Order by optimisations?  (Hannu Krosing <hannu@skype.net>)
Responses Re: Order by optimisations?
Re: Order by optimisations?
List pgsql-hackers
Tree view 
Hannu Krosing <hannu@skype.net> writes:
> On K, 2005-07-13 at 16:08 +0800, Christopher Kings-Lynne wrote:
>> Does it know that the input to the sort routine is already sorted and 
>> hence is a no-op?

> Yes

No, but in most cases this will use an index and hence will assume that
the index is responsible for ordering.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: Order by optimisations?
Next
From: Andrew Dunstan
Date:
Subject: Re: windows regression failure - prepared xacts