Re: upper planner path-ification

From: Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: upper planner path-ification
Date: 2015-06-24 00:42:23
Message-ID: 9A28C8860F777E439AA12E8AEA7694F801109903@BPXM15GP.gisp.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Robert Haas
> Sent: Tuesday, June 23, 2015 10:18 PM
> To: Kaigai Kouhei(海外 浩平)
> Cc: David Rowley; pgsql-hackers(at)postgresql(dot)org; Tom Lane
> Subject: Re: [HACKERS] upper planner path-ification
>
> On Tue, Jun 23, 2015 at 4:41 AM, Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com> wrote:
> > So, unless we don't find out a solution around planner, 2-phase aggregation is
> > like a curry without rice....
>
> Simon and I spoke with Tom about this upper planner path-ification
> problem at PGCon, and he indicated that he intended to work on it
> soon, and that we should bug him about it if he doesn't.
>
> I'm pleased to here this as I seem to have a special talent in that area.
>
It's fantastic support arm.

So, it may be more productive to pay my efforts for investigation
of David Rowley's patch, based on the assumption if we can add
partial/final-aggregation path node as if scan/join-paths.

My interest also stands on his infrastructure.
https://cs.uwaterloo.ca/research/tr/1993/46/file.pdf
It is a bit old paper but good starting point.

Thanks,
--
NEC Business Creation Division / PG-Strom Project
KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-06-24 01:08:36 Re: 9.5 release notes
Previous Message Tom Lane 2015-06-23 23:44:36 Oh, this is embarrassing: init file logic is still broken