Re: performance on new linux box

[Ryan Wexler <ryan@xxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxx> wrote:

Eliot Gable <egable+pgsql-performance@xxxxxxxxx> 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