Re: BUG #16885: PostgreSQL upgrade to 12+ changes hash join to slow nested loop

From: Tavin Cole <tavin(dot)cole(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, tavincole+pgbg(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16885: PostgreSQL upgrade to 12+ changes hash join to slow nested loop
Date: 2021-02-22 14:25:40
Message-ID: CAP93hfzku6m99gFyU8-pv0npvR0Gf4vG3OnLFwsWbyFrGpdOuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Feb 22, 2021 at 3:21 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> you don't need share query - just send an execution plan -
> https://explain.depesz.com/ can do anonymization of the execution plan,
> if it is necessary.
>

v11 plan: https://explain.depesz.com/s/P5Jj
v12 plan: https://explain.depesz.com/s/KPr

Cheers,
Tavin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2021-02-22 15:37:01 Re: BUG #16885: PostgreSQL upgrade to 12+ changes hash join to slow nested loop
Previous Message Pavel Stehule 2021-02-22 14:21:21 Re: BUG #16885: PostgreSQL upgrade to 12+ changes hash join to slow nested loop