Skip site navigation (1) Skip section navigation (2)

Re: performance on new linux box

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 (view raw or flat)
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
>

In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2010-07-08 17:04:05
Subject: Re: performance on new linux box
Previous:From: Kevin GrittnerDate: 2010-07-08 15:02:35
Subject: Re: performance on new linux box

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group