Message-ID: <4C3CF611.1090702@squeakycode.net>
Date: Tue, 13 Jul 2010 18:26:09 -0500
From: Andy Colson <andy@squeakycode.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.4) Gecko/20100608 Lightning/1.0b2 Thunderbird/3.1
MIME-Version: 1.0
To: Ryan Wexler <ryan@iridiumsuite.com>,
 pgsql-performance@postgresql.org
Subject: Re: performance on new linux box
References: <AANLkTinVrej5r_uF3As3mF8BW4CYgLGiw2-v2HORsqjM@mail.gmail.com>
	<4C3532CC.6070601@squeakycode.net>
	<AANLkTiloWDARpJw6xEZwuvSt_iVySIplr0Wg4zThXMPK@mail.gmail.com>
	<4C3591F40200002500033219@gw.wicourts.gov>
	<AANLkTilA1_-XNBcjpVLnbuMndC02PSzsQijzK3gNQc3c@mail.gmail.com>
	<4C35A23B0200002500033220@gw.wicourts.gov>
	<AANLkTilCjMHlvYuHCu5Hf7nd4q5C50Cu5NhTS55F3St9@mail.gmail.com>
	<4C36E6FC.6030902@pws.com.au>
	<AANLkTinzsay4XfpOhcLGCxCVfrOTtbfml05bGMkdGy3-@mail.gmail.com>
	<AANLkTinpCJ4y0v_FwZvP6Bj0o5JCf8Blx2h1EN8NvVDf@mail.gmail.com>
In-Reply-To: <AANLkTinpCJ4y0v_FwZvP6Bj0o5JCf8Blx2h1EN8NvVDf@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 07/11/2010 03:02 PM, Ryan Wexler wrote:

>
> Well I got me a new raid card, MegaRAID 8708EM2, fully equipped with
> BBU and read and write caching are enabled.  It completely solved my
> performance problems.  Now everything is way faster than the previous
> server.  Thanks for all the help everyone.
>
> One question I do have is this card has a setting called Read Policy
> which apparently helps with sequentially reads.  Do you think that is
> something I should enable?
>
>
>

I would think it depends on your usage.  If you use clustered indexes (and understand how/when they help) then enabling it would help (cuz clustered is assuming sequential reads).

or if you seq scan a table, it might help (as long as the table is stored relatively close together).

But if you have a big db, that doesnt fit into cache, and you bounce all over the place doing seeks, I doubt it'll help.

-Andy