Re: BUG #5834: Planner - cost for hash scan too small

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pasman" <pasman(dot)p(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5834: Planner - cost for hash scan too small
Date: 2011-01-13 18:09:42
Message-ID: 20088.1294942182@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Pasman" <pasman(dot)p(at)gmail(dot)com> writes:
> Postgres not estimate cost of creating hash index
> when it plans hash join. Use case:

Yes, it does figure those costs, but they're just folded into the cost
of the hashjoin. The numbers shown for the Hash subnode are only
cosmetic.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-01-13 18:43:23 Re: BUG #5836: Enum Support Functions don't work on empty tables
Previous Message David Pinheiro 2011-01-13 17:33:11 BUG #5836: Enum Support Functions don't work on empty tables