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

Поиск
Список
Период
Сортировка
От Jeremy Evans
Тема Re: BUG #15722: 9000x performance regression on query startingPostgreSQL 10 due to bad query plan
Дата
Msg-id CADGZSSca-cxuFvSzYJL3Rq1=c4QsMa09ZnHUvGLD567JMB-3Ow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15722: 9000x performance regression on query startingPostgreSQL 10 due to bad query plan  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Apr 2, 2019 at 10:11 AM Jeff Janes <jeff.janes@gmail.com> wrote:
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

Jeff,

Sorry for the delay, it took a while to rerun the query on 10.  I've updated the gist to add plain text query plans for 9.6 and 10:


If you would like the query plans for 9.3-9.5 or 11, please let me know. Also, here are links to explain.depesz.com for both query plans:


I originally thought the JSON plans would be more useful, using a viewer such as http://tatiyants.com/pev, that is why I didn't include plain text plans when submitting the bug report.

Thanks,
Jeremy

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #15383: Join Filter cost estimation problem in 10.5
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15734: Walsender process crashing when executing SHOW ALL;