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.Grittner@wicourts.gov> 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