Re: performance on new linux box

On Fri, Jul 9, 2010 at 2:38 AM, Samuel Gendler <sgendler(at)ideasculptor(dot)com>wrote:

> On Fri, Jul 9, 2010 at 2:08 AM, Russell Smith <mr-russ(at)pws(dot)com(dot)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?
> >
>
> The OP mentions that the new system underperforms on a straight dd
> test, so it isn't the database config or postgres build.
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

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?