On Fri, Jul 9, 2010 at 2:38 AM, Samuel Gendler
<sgendler@ideasculptor.com> wrote:
On Fri, Jul 9, 2010 at 2:08 AM, Russell Smith <
mr-russ@pws.com.au> wrote:
> On 09/07/10 02:31, Ryan Wexler wrote:
>
>
> The only other difference between the boxes is the postgresql version. The
> new one has 8.4-2 from the yum install instructions on the site:
>
http://yum.pgrpms.org/reporpms/repoview/pgdg-centos.html >
> Any more thoughts?
>
> Really dumb idea, you don't happen to have the build of the RPM's that had
> debug enabled do you? That resulted in significant performance problem?
>
test, so it isn't the database config or postgres build.
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?