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.gritt...@wicourts.gov>wrote: > Eliot Gable > <egable+pgsql-performa...@gmail.com<egable%2bpgsql-performa...@gmail.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 >