Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does not subquery pruning conditions inherit to parent query? - Mailing list pgsql-hackers

From David Rowley
Subject Re: Why does not subquery pruning conditions inherit to parent query?
Date
Msg-id CAKJS1f_5gH1kWOKDyDGv-msMyfLjXibtjb6MfnERwh26aTONNw@mail.gmail.com
Whole thread Raw
In response to RE: Why does not subquery pruning conditions inherit to parentquery?  ("Kato, Sho" <kato-sho@jp.fujitsu.com>)
Responses RE: Why does not subquery pruning conditions inherit to parentquery?
List pgsql-hackers
Tree view 
On Fri, 31 May 2019 at 03:18, Kato, Sho <kato-sho@jp.fujitsu.com> wrote:
> Is it possible to improve a subquery quals to pull up into outer query?

Sure, it's possible, but it would require writing code. When it can
and cannot/should not be done would need to be determined.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: New committer: David Rowley
Next
From: Tom Lane
Date:
Subject: Re: cpluspluscheck vs vpath