Skip site navigation (1) Skip section navigation (2)

Re: Another optimizer question

From: Dennis Haney <davh(at)diku(dot)dk>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Another optimizer question
Date: 2004-01-27 19:05:51
Message-ID: 4016B68F.6090604@diku.dk (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruno Wolff III wrote:

>On Tue, Jan 27, 2004 at 17:27:25 +0100,
>  Dennis Haney <davh(at)diku(dot)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.
>  
>
Yup, but queries with those are also ignored, so I'm only talking about 
explicit 'order by' without any fancy stuff ;)


-- 
Dennis

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-01-27 19:07:44
Subject: Re: Mixing threaded and non-threaded
Previous:From: Steve AtkinsDate: 2004-01-27 18:48:37
Subject: Re: Mixing threaded and non-threaded

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group