Re: Erroneous cost estimation for nested loop join - Mailing list pgsql-hackers

From KAWAMICHI Ryoji
Subject Re: Erroneous cost estimation for nested loop join
Date
Msg-id 545319161.13041927.1447316357383.JavaMail.zimbra@tkl.iis.u-tokyo.ac.jp
Whole thread Raw
In response to Re: Erroneous cost estimation for nested loop join  ("Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>)
List pgsql-hackers
<oleksandr.shulgin@zalando.de> wrote:
>>
>>       - cost parameter calibration: random_page_cost = 92.89
>>
> 
> This demands some explanation and raises question of value of seq_page_cost
> parameter -- I don't see anything about it your mail.

seq_page_cost was set to 1.0 (default), and I explained the reason about random_page_cost value in reply to Tom.
Please see it.

Thanks
Ryoji



pgsql-hackers by date:

Previous
From: KAWAMICHI Ryoji
Date:
Subject: Re: Erroneous cost estimation for nested loop join
Next
From: KAWAMICHI Ryoji
Date:
Subject: Re: Erroneous cost estimation for nested loop join