Re: Introducing a new linux readahead framework - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Introducing a new linux readahead framework
Date
Msg-id 20060421183423.GL49405@pervasive.com
Whole thread Raw
In response to Re: Introducing a new linux readahead framework  (Wu Fengguang <wfg@mail.ustc.edu.cn>)
Responses Re: Introducing a new linux readahead framework  (Wu Fengguang <wfg@mail.ustc.edu.cn>)
List pgsql-performance
On Fri, Apr 21, 2006 at 08:20:28PM +0800, Wu Fengguang wrote:
> Hi Markus,
>
> On Fri, Apr 21, 2006 at 09:53:34AM +0200, Markus Schaber wrote:
> > Are there any rough estimates when this will get into mainline kernel
> > (if you intend to submit)?
>
> I'm not quite sure :)
>
> The patch itself has been pretty stable.  To get it accepted, we must
> back it by good benchmarking results for some important applications.
> I have confirmed that file service via FTP/HTTP/NFS can more or less
> benefit from it. However, database services have not been touched yet.
> Oracle/DB2 seem to bypass the readahead code route, while postgresql
> relies totally on kernel readahead logic. So if postgresql is proved
> to work well with this patch, it will have good opportunity to go into
> mainline :)

IIRC Mark from OSDL said he'd try testing this when he gets a chance,
but you could also try running dbt2 and dbt3 against it.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Takes too long to fetch the data from database
Next
From: "Mikael Carneholm"
Date:
Subject: Re: Hardware: HP StorageWorks MSA 1500