Re: Is there a meaningful benchmark? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Is there a meaningful benchmark?
Date
Msg-id dcc563d10903191513k39aaf1d1jc06b83d315196a73@mail.gmail.com
Whole thread Raw
In response to Re: Is there a meaningful benchmark?  ("Will Rutherdale (rutherw)" <rutherw@cisco.com>)
Responses Re: Is there a meaningful benchmark?  ("Will Rutherdale (rutherw)" <rutherw@cisco.com>)
List pgsql-general
On Thu, Mar 19, 2009 at 3:56 PM, Will Rutherdale (rutherw)
<rutherw@cisco.com> wrote:
> I'm having trouble with the tweakers reference below.
>
> I was hoping to see something where hardware platform is held constant while RDBMS is varied, but it seems to be just
theopposite.  Or maybe I didn't read the article the right way. 

The tweakers test is actually VERY telling.  With a constant load, how
well do the database scale as you improve the hardware you've given
them to run on.  Hardware is cheap, downtime is not.  If you can toss
a 16 core server at a performance problem for $20,000 or so, that's
probably way cheaper than watching your main db chug under load and go
down twice a day.

Conversely, telling the bossman you need that 16 core server to
improve performance and seeing the new server collapse under load
faster than the old one due to poor concurrency is not gonna win you a
lot of brownie points.

pgsql-general by date:

Previous
From: "Will Rutherdale (rutherw)"
Date:
Subject: Re: Is there a meaningful benchmark?
Next
From: Scott Marlowe
Date:
Subject: Re: Is there a meaningful benchmark?