Re: BUG #15722: 9000x performance regression on query starting PostgreSQL 10 due to bad query plan

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: jeremyevans0(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15722: 9000x performance regression on query starting PostgreSQL 10 due to bad query plan
Date: 2019-04-02 17:10:48
Message-ID: CAMkU=1x6089xnznmkZi093R7CBqJeqjo6CK7F-R2S4N2KR6oKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Mar 29, 2019 at 6:53 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

>
> The following files are available at
> https://gist.github.com/jeremyevans/8a9693b1d3f14c94f635b1bf4275b2be
>
>
Could you also include the human readable explain plans (even just for 9.6.
and 10)? JSON objects with 1900 lines might be good for machines, but not
for people. (Of course the human readable format might not be all that
readable either, but it is worth a shot)

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-04-02 17:11:52 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Previous Message r.zharkov 2019-04-02 17:04:15 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed