Re: Parameterized aggregate subquery

Yeb Havinga <yebhavinga@gmail.com>

From: Yeb Havinga <yebhavinga@gmail.com>
To: Hitoshi Harada <umi.tanuki@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-06-30T08:03:22Z
Lists: pgsql-hackers
On 2011-06-30 09:39, Yeb Havinga wrote:
>
> 9) as remarked up a different thread, more than one clause could be 
> pushed down a subquery. The current patch only considers alternative 
> paths that have at most one clause pushed down. Is this because of the 
> call site of best_inner_subqueryscan, i.e. under one join rel? Would 
> it be an idea to consider, for each subquery, only a single 
> alternative plan that tries to have all suitable clauses pushed down?

Ehm, please forget this remark, I've mistaken join rel for base rel.

-- Yeb