Re: BUG #14642: Excessive sorting node appears in the plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bashtanov(at)imap(dot)cc
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14642: Excessive sorting node appears in the plan
Date: 2017-05-04 14:12:57
Message-ID: 6817.1493907177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

bashtanov(at)imap(dot)cc writes:
> Do blackbox-style subplans, such as subqueries with grouping, share only the
> resulting stream order info with the enclosing query, not the equivalence
> classes?

Yes, see convert_subquery_pathkeys().

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2017-05-04 14:34:10 Re: BUG #14642: Excessive sorting node appears in the plan
Previous Message bashtanov 2017-05-04 12:29:23 BUG #14642: Excessive sorting node appears in the plan