[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: Query Performance Issue
From: David Rowley <david.rowley () 2ndquadrant ! com>
Date: 2018-12-29 22:00:08
Message-ID: CAKJS1f_KzGZ7SRwNMknu59J8a3mAxR1=JAZZPmrdcsQCT1Djmg () mail ! gmail ! com
[Download RAW message or body]
On Sat, 29 Dec 2018 at 20:15, Justin Pryzby <pryzby@telsasoft.com> 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic