Re: [HACKERS] GSoC 2017 - Mailing list pgsql-hackers

From Dmitry Melnik
Subject Re: [HACKERS] GSoC 2017
Date
Msg-id CADviLuN9jKULf23Sgw7MYO7smtEEbF5pAGhNm=wfLnO0OP48Aw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] GSoC 2017  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
The expected result for this work is push-based executor working for many types of queries (currently we aim at TPC-H), but it's unlikely to be a production-ready patch to commit into mainline at that stage. This work is the actual topic for our student's thesis, so he has already started, and has working prototypes for very simple plans. Also, he won't be working on this alone, but rather will make use of support and experience of our team (as well as mentor's help).
So this is not about replacing current pull executor right away, but rather to develop working prototype to find out about the benefits of switching from pull to push model (for both the interpreter and LLVM JIT).

On Wed, Feb 8, 2017 at 7:06 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Mon, Feb 6, 2017 at 6:51 AM, Ruben Buchatskiy <ruben@ispras.ru> wrote:
> 2017-01-10 12:53 GMT+03:00 Alexander Korotkov <a.korotkov@postgrespro.ru>:
>> 1. What project ideas we have?
>
> We would like to propose a project on rewriting PostgreSQL executor from
>
> traditional Volcano-style [1] to so-called push-based architecture as
> implemented in
>
> Hyper [2][3] and VitesseDB [4]. The idea is to reverse the direction of data
> flow
>
> control: instead of pulling up tuples one-by-one with ExecProcNode(), we
> suggest
>
> pushing them from below to top until blocking operator (e.g. Aggregation) is
>
> encountered. There’s a good example and more detailed explanation for this
> approach in [2].

I think this very possibly a good idea but extremely unlikely to be
something that a college student or graduate student can complete in
one summer.  More like an existing expert developer and a year of
doing not much else.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



--
Best regards,
  Dmitry

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: [HACKERS] removing tsearch2
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] removing tsearch2