Re: BUG #15383: Join Filter cost estimation problem in 10.5

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15383: Join Filter cost estimation problem in 10.5
Date: 2019-07-01 02:14:47
Message-ID: CAKJS1f94GPHjbnGg1_xzqfzzKDRc2O6Bq8ge64xCg8UbP09ZqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Sat, 29 Jun 2019 at 10:06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> > On 2019-Apr-03, Tom Lane wrote:
> >> Ping? If nobody has any further ideas here, I'm going to clean up
> >> the regression test issue and push this.
>
> > Is this still live? If so, is it something for pg12?
>
> It's still live --- Rowley seemed not happy with my proposal so
> I didn't push it. I'm not sure that it's must-fix-for-v12;
> the problem is older than that.

One thing we could look at would be to charge an additional
cpu_tuple_cost per outer row for all joins except semi, anti and
unique joins. This would account for the additional lookup for
another matching row which won't be found and cause the planner to
slightly favour keeping the unique rel on the inner side of the join,
when everything else is equal.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-07-02 08:28:18 BUG #15882: Select .... UNION ALL
Previous Message Tom Lane 2019-06-30 18:52:44 Re: BUG #15121: Multiple UBSAN errors

Browse pgsql-hackers by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2019-07-01 02:59:17 RE: Zedstore - compressed in-core columnar storage
Previous Message Michael Paquier 2019-07-01 01:02:15 Re: Fix typos and inconsistencies for HEAD