Re: Parameterized aggregate subquery

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Parameterized aggregate subquery
Date: 2011-06-30 08:03:22
Message-ID: 4E0C2DCA.7090402@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Radosław Smogura 2011-06-30 08:33:57 Re: Review of patch Bugfix for XPATH() if expression returns a scalar value
Previous Message Heikki Linnakangas 2011-06-30 07:58:01 Re: Latch implementation that wakes on postmaster death on both win32 and Unix