Postgres Pro
Downloads
Home   >   mailing lists

Re: Another optimizer question - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Another optimizer question
Date
Msg-id 20040127174135.GA14806@wolff.to
Whole thread Raw
In response to Another optimizer question  (Dennis Haney <davh@diku.dk>)
Responses Re: Another optimizer question  (Dennis Haney <davh@diku.dk>)
List pgsql-hackers
Tree view 
On Tue, Jan 27, 2004 at 17:27:25 +0100, Dennis Haney <davh@diku.dk> wrote:
> 
> Is it just me, or is there any way a sort could be relevant in a 
> subquery? (except on queries containing volatile functions)

Yes. It is important when a limit or distinct on clause is used in a
subquery.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: index scan with functional indexes
Next
From: Dave Cramer
Date:
Subject: Re: index scan with functional indexes