From: | Michael Renner <michael(dot)renner(at)amd(dot)co(dot)at> |
---|---|
To: | Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Cc: | christian(at)hofstaedtler(dot)name |
Subject: | Re: How is random_page_cost=4 ok? |
Date: | 2008-10-13 20:49:40 |
Message-ID: | 48F3B464.4060806@amd.co.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2008-10-13 21:38:20 | Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED |
Previous Message | Joshua Drake | 2008-10-13 20:45:35 | Re: TODO item: adding VERBOSE option to CLUSTER [with patch] |