Re: Proposed patch to make mergejoin cost estimation more symmetric - Mailing list pgsql-patches

From Tom Lane
Subject Re: Proposed patch to make mergejoin cost estimation more symmetric
Date
Msg-id 19957.1197040535@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposed patch to make mergejoin cost estimation more symmetric  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Yes, but how can you tell by looking at the explain?  I think the point
> is that the "fraction that would be skipped" should be reported somehow.

It is: it's directly reflected in the startup cost.  Previously, a
mergejoin would always have startup cost equal to the sum of its
input startup costs (hence, zero in the cases of interest here).

            regards, tom lane

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Proposed patch to make mergejoin cost estimation more symmetric
Next
From: xeb@mail.ru
Date:
Subject: [PATCH] automatic integer conversion