Re: Query Performance Issue
От
David Rowley
Тема
Re: Query Performance Issue
Дата
Msg-id
CAKJS1f_KzGZ7SRwNMknu59J8a3mAxR1=JAZZPmrdcsQCT1Djmg@mail.gmail.com
Ответ на
Re: Query Performance Issue (Justin Pryzby)
Список
Дерево обсуждения
Query Performance Issue neslişah demirci <neslisah.demirci@gmail.com>
Re: Query Performance Issue Justin Pryzby <pryzby@telsasoft.com>
Re: Query Performance Issue David Rowley <david.rowley@2ndquadrant.com>
Re: Query Performance Issue Justin Pryzby <pryzby@telsasoft.com>
Re: Query Performance Issue Jim Finnerty <jfinnert@amazon.com>
Re: Query Performance Issue David Rowley <david.rowley@2ndquadrant.com>
Re: Query Performance Issue Jeff Janes <jeff.janes@gmail.com>
Re: Query Performance Issue Alexey Bashtanov <bashtanov@imap.cc>
On Sat, 29 Dec 2018 at 20:15, Justin Pryzby wrote: > On Sat, Dec 29, 2018 at 07:58:28PM +1300, David Rowley wrote: > > Unfortunately, I don't think that'll help this situation. Extended > > statistics are currently only handled for base quals, not join quals. > > See dependency_is_compatible_clause(). > > Right, understand. > > Corrrect me if I'm wrong though, but I think the first major misestimate is in > the scan, not the join: I should have checked more carefully. Of course, they are base quals. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-performance по дате отправления
