Re: Erroneous cost estimation for nested loop join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Erroneous cost estimation for nested loop join
Дата
Msg-id 22565.1447079844@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Erroneous cost estimation for nested loop join  (kawamichi@tkl.iis.u-tokyo.ac.jp)
Ответы Re: Erroneous cost estimation for nested loop join
Re: Erroneous cost estimation for nested loop join
Список pgsql-hackers
kawamichi@tkl.iis.u-tokyo.ac.jp writes:
>       - cost parameter calibration: random_page_cost = 92.89

TBH, you lost me there already.  I know of no hardware on which that would
be a sane depiction of reality, so I think you've probably overfitted the
model to some particular case it was already inaccurate on.  Any results
you're getting using this setting will likely fall into the category of
"garbage in, garbage out".

What led you to choose that number?
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: PL/Pythonu - function ereport
Следующее
От: Robert Haas
Дата:
Сообщение: Re: CustomScan support on readfuncs.c