Re: cpu_tuple_cost

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cpu_tuple_cost
Дата
Msg-id 8149.1111005738@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: cpu_tuple_cost  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: cpu_tuple_cost
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> So what's going on with the empirically derived value of 4?

> It's not empirically derived;

Yes it is.  I ran experiments back in the late 90s to derive it.
Check the archives.

Disks have gotten noticeably bigger since then, but I don't think
the ratio of seek time to rotation rate has changed much.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Performance problem on delete from for 10k rows. May
Следующее
От: David Brown
Дата:
Сообщение: Re: multi-column index