On Sat, 29 Dec 2018 at 20:15, Justin Pryzby <pryzby@xxxxxxxxxxxxx> 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
