Re: How is random_page_cost=4 ok?

Поиск
Список
Период
Сортировка
От Michael Renner
Тема Re: How is random_page_cost=4 ok?
Дата
Msg-id 48F3B464.4060806@amd.co.at
обсуждение исходный текст
Ответ на Re: How is random_page_cost=4 ok?  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-hackers
Greg Smith wrote:

> The drives themselves, and possibly the OS and disk controller, are all 
> running read-ahead algorithms to accelerate this case.  In fact, this 
> *exact* case for the Linux read-ahead stuff that just went mainline 
> recently: http://kerneltrap.org/node/6642

Apparently only the "simple" stuff hit mainline, see [1] and [2], not 
knowing how this turns out for pg-style loads, especially compared to 
the full-fledged patch.

Readahead is probably too much of a beast that no one dares to touch 
with a 3-foot-pole, unless given a large team with good standing in the 
kernel community and concerted regression testing in whatever 
environment Linux is used these days...


michael


[1] http://lwn.net/Articles/235164/
[2] 
http://git.kernel.org/?p=linux/kernel/git/torvalds/linux-2.6.git;a=history;f=mm/readahead.c


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

Предыдущее
От: Joshua Drake
Дата:
Сообщение: Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED