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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-01-27 19:07:44 Re: Mixing threaded and non-threaded
Previous Message Steve Atkins 2004-01-27 18:48:37 Re: Mixing threaded and non-threaded