Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem

Daniel Ferreira de Lima wrote:
>
>
>
>     > **Both with Linux Kernel 2 .4.37.9 and Postgresql 7.2**
>
>     Wow.  You really need to upgrade.
>
>
> Yes, but unfortunately, actually it's impossible and economically
> inviable...

Generally, getting good performance out of PostgreSQL 7.2 is also
impossible and economically inviable.  You can either put resources
toward upgrading to a newer version, which will fix many of the
performance issues here, or toward changes to the old version that are
not guaranteed to actually improve anything.

That said, a look into the write-caching+BBU policy on your controller
is worthwhile.  If you're running this application successfully on some
hardware but not others, that could be a source for the difference.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us