| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | neslişah demirci <neslisah(dot)demirci(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Query Performance Issue |
| Date: | 2018-12-29 22:00:08 |
| Message-ID: | CAKJS1f_KzGZ7SRwNMknu59J8a3mAxR1=JAZZPmrdcsQCT1Djmg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, 29 Dec 2018 at 20:15, Justin Pryzby <pryzby(at)telsasoft(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Finnerty | 2018-12-30 01:25:09 | Re: Need help with optimising simple query |
| Previous Message | Jeff Janes | 2018-12-29 20:27:39 | Re: Query Performance Issue |