Home > mailing lists

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

From	Shulgin, Oleksandr
Subject	Re: Erroneous cost estimation for nested loop join
Date	November 9, 2015 13:27:26
Msg-id	CACACo5STPGs7kJ5QQqD0YBLDwRAn-U=aAdxY1FyNRV2=aWgMKw@mail.gmail.com Whole thread Raw
In response to	Erroneous cost estimation for nested loop join (kawamichi@tkl.iis.u-tokyo.ac.jp)
Responses	Re: Erroneous cost estimation for nested loop join
List	pgsql-hackers

On Mon, Nov 9, 2015 at 11:08 AM, <kawamichi@tkl.iis.u-tokyo.ac.jp> 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.

Alex

From: kawamichi@tkl.iis.u-tokyo.ac.jp
Date: 09 November 2015, 13:09:16
Subject: Erroneous cost estimation for nested loop join

From: Etsuro Fujita
Date: 09 November 2015, 13:35:20
Subject: Minor comment improvement to create_foreignscan_plan