Re: BUG #5834: Planner - cost for hash scan too small - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5834: Planner - cost for hash scan too small
Date
Msg-id 20088.1294942182@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5834: Planner - cost for hash scan too small  ("Pasman" <pasman.p@gmail.com>)
List pgsql-bugs
"Pasman" <pasman.p@gmail.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

pgsql-bugs by date:

Previous
From: "Julien Demoor"
Date:
Subject: BUG #5835: PL/Python crashes
Next
From: "David Pinheiro"
Date:
Subject: BUG #5836: Enum Support Functions don't work on empty tables