Re: Optimizer choosing the wrong plan
От
Jim Finnerty
Тема
Re: Optimizer choosing the wrong plan
Дата
Msg-id
1546085853213-0.post@n3.nabble.com
Ответ на
Re: Optimizer choosing the wrong plan (Jeff Janes)
Список
Дерево обсуждения
Optimizer choosing the wrong plan Viswanath <M.Viswanath16@gmail.com>
Re: Optimizer choosing the wrong plan Jeff Janes <jeff.janes@gmail.com>
Re: Optimizer choosing the wrong plan Jim Finnerty <jfinnert@amazon.com>
Re: Optimizer choosing the wrong plan Jeff Janes <jeff.janes@gmail.com>
re: It would interesting if you can upgrade a copy of your server to v11 and
try it there. We made changes to ANALYZE in that version which were
intended to improve this situation, and it would be nice to know if it
actually did so for your case.
Jeff, can you describe the changes that were made to ANALYZE in v11, please?
I've found that running ANALYZE on v10 on the Join Order Benchmark, using
the default statistics target of 100, produces quite unstable results, so
I'd be interested to hear what has been improved in v11.
/Jim
-----
Jim Finnerty, AWS, Amazon Aurora PostgreSQL
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
В списке pgsql-performance по дате отправления
