Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8C00464FCD5 for ; Thu, 11 Sep 2008 16:53:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06490-02 for ; Thu, 11 Sep 2008 16:53:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pih-relay04.plus.net (pih-relay04.plus.net [212.159.14.17]) by postgresql.org (Postfix) with ESMTP id 0AAA764FCD2 for ; Thu, 11 Sep 2008 16:53:31 -0300 (ADT) Received: from [80.229.150.39] (helo=pd600.barnhouse) by pih-relay04.plus.net with esmtp (Exim) id 1KdsEK-0002kT-Da; Thu, 11 Sep 2008 20:53:28 +0100 Received: from [192.168.0.87] (unknown [192.168.0.87]) by pd600.barnhouse (Postfix) with ESMTP id BC5E84E1D9F; Thu, 11 Sep 2008 20:59:18 +0100 (BST) Message-ID: <48C97793.2070909@mansionfamily.plus.com> Date: Thu, 11 Sep 2008 20:54:59 +0100 From: James Mansion Organization: MsgWare User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: Greg Smith CC: pgsql-performance@postgresql.org Subject: Re: Effects of setting linux block device readahead size References: <70c01d1d0809092353r4ae687a3ycf3d99d43a5680cf@mail.gmail.com> <48C8AACD.5090702@mansionfamily.plus.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: eaf6e8a2151627d3f5a6b6623ce0322d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/143 X-Sequence-Number: 31456 Greg Smith wrote: > The point I was trying to make there is that even under impossibly > optimal circumstances, you'd be hard pressed to blow out the disk's > read cache with seek-dominated data even if you read a lot at each > seek point. That idea didn't make it from my head into writing very > well though. > Isn't there a bigger danger in blowing out the cache on the controller and causing premature pageout of its dirty pages? If you could get the readahead to work on the drive and not return data to the controller, that might be dandy, but I'm sceptical. James