Re: using custom scan nodes to prototype parallel sequential scan - Mailing list pgsql-hackers

From Kouhei Kaigai
Subject Re: using custom scan nodes to prototype parallel sequential scan
Date
Msg-id 9A28C8860F777E439AA12E8AEA7694F801078DED@BPXM15GP.gisp.nec.co.jp
Whole thread Raw
In response to Re: using custom scan nodes to prototype parallel sequential scan  (David Rowley <dgrowley@gmail.com>)
List pgsql-hackers
> On 18 November 2014 05:19, Simon Riggs <simon@2ndquadrant.com> wrote:
> 
> 
>     On 14 November 2014 11:02, Kouhei Kaigai <kaigai@ak.jp.nec.com>
> wrote:
> 
>     > I'd like to throw community folks a question.
>     > Did someone have a discussion to the challenge of aggregate
> push-down across
>     > relations join in the past? It potentially reduces number of rows
> to be joined.
>     > If we already had, I'd like to check up the discussion at that
> time.
> 
>     Yes, I was looking at aggregate pushdown. I think it needs the same
>     changes to aggregates discussed upthread.
> 
> 
> 
> 
> I have something that I've been working on locally. It's far from ready,
> but it does work in very simple cases, and shows a nice performance boost.
> I'll start another thread soon and copy you both in. Perhaps we can share
> some ideas.
> 
Great, it's exactly valuable functionality to be in the core.

--
NEC OSS Promotion Center / PG-Strom Project
KaiGai Kohei <kaigai@ak.jp.nec.com>

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql - Assert statement
Next
From: Michael Paquier
Date:
Subject: Re: [TODO] Track number of files ready to be archived in pg_stat_archiver