Re: Buffers from parallel workers not accumulated to upper nodes with gather merge

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Buffers from parallel workers not accumulated to upper nodes with gather merge
Date: 2020-07-23 10:14:16
Message-ID: CAA4eK1+GYBCTZ-P9xVUg6mSvM7umKf5O8ZGXTJA85myS5BYe=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jul 21, 2020 at 9:05 PM Jehan-Guillaume de Rorthais
<jgdr(at)dalibo(dot)com> wrote:
>
> On Mon, 20 Jul 2020 15:29:00 +0530
> Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
>
> > BTW, can you please test if the problem exist in back-branches, and does
> > your change fix it there as well?
>
> Gather Merge appears in v10, but I haven't been able to produce a plan using it.
>

I am able to do it for v10. I think you can try by "set
enable_hashagg = off;" and following all other steps mentioned in your
email? Attached, please find the patch for v10 with a modified commit
message. I will do it for other versions as well if you are fine with
it?

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Attachment Content-Type Size
v2-0001-Fix-buffer-usage-stats-for-nodes-above-Gather-Merge.patch application/octet-stream 1.7 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jehan-Guillaume de Rorthais 2020-07-23 10:29:09 Re: Buffers from parallel workers not accumulated to upper nodes with gather merge
Previous Message Jehan-Guillaume de Rorthais 2020-07-23 09:07:49 Re: Buffers from parallel workers not accumulated to upper nodes with gather merge