Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1URYMW-0002yN-Mh for pgsql-students@arkaria.postgresql.org; Mon, 15 Apr 2013 01:37:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1URYMV-0006pA-FU for pgsql-students@arkaria.postgresql.org; Mon, 15 Apr 2013 01:37:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1URYMU-0006p4-Qf for pgsql-students@postgresql.org; Mon, 15 Apr 2013 01:37:38 +0000 Received: from mail.gransy.com ([2001:1528:137::f1]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1URYMQ-0000eP-D7 for pgsql-students@postgresql.org; Mon, 15 Apr 2013 01:37:37 +0000 Received: from antispam.gransy.com (antispam.gransy.com [77.78.104.124]) by mail.gransy.com (Postfix) with ESMTP id F3A675087C8 for ; Mon, 15 Apr 2013 03:37:30 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at antispam.gransy.com Received: from mail.gransy.com ([82.208.44.189]) by antispam.gransy.com (antispam.gransy.com [77.78.104.124]) (amavisd-new, port 10024) with ESMTP id 1aN__udeQpqt for ; Mon, 15 Apr 2013 03:37:30 +0200 (CEST) Received: by mail.gransy.com (Postfix, from userid 5000) id 4B40A50880F; Mon, 15 Apr 2013 03:37:29 +0200 (CEST) Received: from [192.168.1.237] (ip-78-45-133-255.net.upcbroadband.cz [78.45.133.255]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gransy.com (Postfix) with ESMTPSA id 1D3A25087C8 for ; Mon, 15 Apr 2013 03:37:29 +0200 (CEST) Message-ID: <516B59D9.5070106@fuzzy.cz> Date: Mon, 15 Apr 2013 03:37:29 +0200 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130328 Thunderbird/17.0.5 MIME-Version: 1.0 To: pgsql-students@postgresql.org Subject: Re: Google Summer of code 2013 References: <20130413183912.e74dfcdc8f0072e2b6c2fb24@gmail.com> <20130414221640.GQ4361@tamriel.snowman.net> In-Reply-To: <20130414221640.GQ4361@tamriel.snowman.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-students Precedence: bulk Sender: pgsql-students-owner@postgresql.org Hi, I've briefly discussed the project with the student a while back, so a few thoughts on the project: On 15.4.2013 00:16, Stephen Frost wrote: > * Karel K. Rozho=C5=88 (karel.rozhon@gmail.com) wrote: >> What do you think about this project?=20 >=20 > Parallelization in PG is a pretty massive discussion and probably not > suited to a GSoC project. Once we have the groundwork for doing There's certainly a lot of groundwork to do, and I do share the concern that the project will have to deal with a lot of dirty work (e.g. when transfering data between the processes). But couldn't it be a useful part of the discussion? I don't expect a commitable patch at the end, but rather something that "works" and may be used as a basis for improvements and to build the actual groundwork. > parallel processing for a given query, I doubt that hash tables will be > the first piece implemented. I think that depends on the workload type. For example for databases handling DWH-like queries, parallel hash aggregate is going to be a major improvement. Karel mentioned he's currently working on his bachelor thesis, which is about hash tables too. That's another reason why he proposed this topic. regards Tomas --=20 Sent via pgsql-students mailing list (pgsql-students@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-students