Re: How is random_page_cost=4 ok?

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

In response to

Browse pgsql-hackers by date

  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]