Re: Hash Join cost estimates - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Hash Join cost estimates
Date
Msg-id 20130330201525.GY4361@tamriel.snowman.net
Whole thread Raw
In response to Re: Hash Join cost estimates  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff,

* Jeff Davis (pgsql@j-davis.com) wrote:
> On Thu, 2013-03-28 at 19:56 -0400, Stephen Frost wrote:
> >   41K hashed, seqscan 4M: 115030.10 + 1229.46 = 116259.56
> >   4M hashed, seqscan 41K: 1229.46 + 211156.20 = 212385.66
>
> I think those are backwards -- typo?

Yes, sorry, those are backwards.  The '4M hashed, seqscan 41K' entry
comes out with the lower cost and that's what we end up using.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: HS and clog
Next
From: Stephen Frost
Date:
Subject: Re: Hash Join cost estimates