Re: Gather Merge

From: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Gather Merge
Date: 2017-02-17 12:52:14
Message-ID: CAGPqQf0h1He7J+Jwi457wRXre3VW1oREVzCEgAQAA7h-qHszxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 17, 2017 at 3:59 PM, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com
> wrote:

> On Thu, Feb 2, 2017 at 2:32 AM, Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
> wrote:
> > Please find attached latest patch.
>
> The latest patch still applies (with some fuzz), builds and the
> regression tests pass.
>
> Attached latest patch, which applies cleanly on latest source.

> I see that Robert made a number of changes and posted a v6 along with
> some numbers which he described as lacklustre, but then fixed a row
> estimate problem which was discouraging parallel joins (commit
> 0c2070ce). Rushabh posted a v7 and test results which look good. As
> far as I can see there are no outstanding issues or unhandled review
> feedback. I've had a fresh read through of the latest version and
> have no further comments myself.
>
> I've set this to ready-for-committer now. If I've misunderstood and
> there are still unresolved issues from that earlier email exchange or
> someone else wants to post a review or objection, then of course
> please feel free to set it back.
>
>
Thanks Thomas.

> BTW There is no regression test supplied. I see that commit 5262f7a4
> adding parallel index scans put simple explain output in
> "select_parallel" to demonstrate the new kind of plan being created;
> perhaps this patch should do the same? I know it wouldn't really test
> much of the code but it's at least something. Perhaps you could post
> a new version with that?
>
>
Added the regression test to the new version of patch.

PFA latest patch.

--
Rushabh Lathia
www.EnterpriseDB.com

Attachment Content-Type Size
gather-merge-v8.patch application/x-download 54.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2017-02-17 12:53:24 Re: REINDEX CONCURRENTLY 2.0
Previous Message Greg Stark 2017-02-17 11:51:50 Re: Sum aggregate calculation for single precsion real