On Fri, Jul 9, 2010 at 2:38 AM, Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx> wrote:
On Fri, Jul 9, 2010 at 2:08 AM, Russell Smith <mr-russ@xxxxxxxxxx> wrote:
> On 09/07/10 02:31, Ryan Wexler wrote:
>
>
> The only other difference between the boxes is the postgresql version. TheThe OP mentions that the new system underperforms on a straight dd
> 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.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
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?
