From: | Ryan Wexler <ryan(at)iridiumsuite(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | Eliot Gable <egable+pgsql-performance(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, Andy Colson <andy(at)squeakycode(dot)net> |
Subject: | Re: performance on new linux box |
Date: | 2010-07-08 16:31:32 |
Message-ID: | AANLkTilCjMHlvYuHCu5Hf7nd4q5C50Cu5NhTS55F3St9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks a lot for all the comments. The fact that both my windows box and
the old linux box both show a massive performance improvement over the new
linux box seems to point to hardware to me. I am not sure how to test the
fsync issue, but i don't see how that could be it.
The raid card the server has in it is:
3Ware 4 Port 9650SE-4LPML RAID Card
Looking it up, it seems to indicate that it has BBU
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?
On Thu, Jul 8, 2010 at 8:02 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov>wrote:
> Eliot Gable <egable+pgsql-performance(at)gmail(dot)com<egable%2Bpgsql-performance(at)gmail(dot)com>>
> wrote:
>
> > If you can post some of your queries, there are a lot of bright
> > people on this discussion list that can probably help you solve
> > your bottleneck
>
> Sure, but the original post was because the brand new server class
> machine was performing much worse than the single-drive desktop
> machine *on the same queries*, which seems like an issue worthy of
> investigation independently of what you suggest.
>
> -Kevin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2010-07-08 17:04:05 | Re: performance on new linux box |
Previous Message | Kevin Grittner | 2010-07-08 15:02:35 | Re: performance on new linux box |