Re: BUG #15847: Running out of memory when planning full outer joins involving many partitions

From: Feike Steenbergen <feikesteenbergen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15847: Running out of memory when planning full outer joins involving many partitions
Date: 2019-06-14 08:26:35
Message-ID: CAK_s-G175+izX1roPoBujGQ=P03qJ=au5AsOeEg4XqCcTCd+bQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, 13 Jun 2019 at 19:14, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> This patch fixes the
> described performance problem and still passes check-world.

Thanks! I can see drastic improvements in a 3-way join
and the 4-way join is now actually working.

Feike

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sébastien Lardière 2019-06-14 09:22:57 Recursive CTE and collation
Previous Message David Rowley 2019-06-14 01:17:22 Re: BUG #15851: Concurrent Refresh of Materialized views not preserving the order of the underlying query