Re: What about utility to calculate planner cost constants?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What about utility to calculate planner cost constants?
Дата
Msg-id 10950.1111517770@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What about utility to calculate planner cost constants?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> Christopher Browne <cbbrowne@acm.org> writes:
>> Are you certain it's a linear system?

> If you just consider the guc parameters that tell postgres how long various
> real world operations take (all the *_cost parameters) then it's a linear
> system. It has to be.

No it doesn't.  Think caching effects for instance.  We do have cache
effects in the cost models, even though they are wrong as per my nearby
rant...

            regards, tom lane

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

Предыдущее
От: Thomas F.O'Connell
Дата:
Сообщение: Re: [ADMIN] Too slow
Следующее
От: Alex Turner
Дата:
Сообщение: Re: Planner issue