Re: Proposed patch to make mergejoin cost estimation more symmetric

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: Proposed patch to make mergejoin cost estimation more symmetric
Date: 2007-12-07 15:15:35
Message-ID: 19957.1197040535@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-12-07 15:37:45 Re: Problem with ControlFileData structure being ABI depe ndent
Previous Message Simon Riggs 2007-12-07 15:14:45 Re: Proposed patch to make mergejoin cost estimation more symmetric