Re: BUG #15722: 9000x performance regression on query startingPostgreSQL 10 due to bad query plan - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15722: 9000x performance regression on query startingPostgreSQL 10 due to bad query plan
Date
Msg-id CAMkU=1x6089xnznmkZi093R7CBqJeqjo6CK7F-R2S4N2KR6oKw@mail.gmail.com
Whole thread Raw
In response to BUG #15722: 9000x performance regression on query starting PostgreSQL 10 due to bad query plan  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15722: 9000x performance regression on query startingPostgreSQL 10 due to bad query plan  (Jeremy Evans <jeremyevans0@gmail.com>)
List pgsql-bugs
On Fri, Mar 29, 2019 at 6:53 AM PG Bug reporting form <noreply@postgresql.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

pgsql-bugs by date:

Previous
From: r.zharkov@postgrespro.ru
Date:
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it wasalready committed
Next
From: Andres Freund
Date:
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it wasalready committed