Re: Erroneous cost estimation for nested loop join

From: KAWAMICHI Ryoji <kawamichi(at)tkl(dot)iis(dot)u-tokyo(dot)ac(dot)jp>
To: "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Erroneous cost estimation for nested loop join
Date: 2015-11-12 08:19:17
Message-ID: 545319161.13041927.1447316357383.JavaMail.zimbra@tkl.iis.u-tokyo.ac.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


<oleksandr(dot)shulgin(at)zalando(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message KAWAMICHI Ryoji 2015-11-12 08:21:51 Re: Erroneous cost estimation for nested loop join
Previous Message KAWAMICHI Ryoji 2015-11-12 08:17:39 Re: Erroneous cost estimation for nested loop join