| 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: | Whole Thread | Raw Message | 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
| 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 |