Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Re: Need help with 8.4 Performance Testing - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Need help with 8.4 Performance Testing
Date
Msg-id dcc563d10812072140q1cb257cbs8140b390759cb1a5@mail.gmail.com
Whole thread Raw
In response to Need help with 8.4 Performance Testing  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Need help with 8.4 Performance Testing
List pgsql-performance
On Sun, Dec 7, 2008 at 12:38 PM, Josh Berkus <josh@agliodbs.com> wrote:

I've got a pair of 8 core opteron 16 drive machines I would like to
test it on.  If nothing else I'll just take queries from the log to
run against an 8.4 install.  It'll have to be late at night though...

> If you are going to use pgbench to test, *please* read Greg Smith's notes
> first:
> http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgbench-scaling.htm

When I last used pgbench I wanted to test it with an extremely large
dataset, but it maxes out at -s 4xxx or so, and that's only in the
40Gigabyte range.  Is the limit raised for the pgbench included in
contrib in 8.4?  I'm guessing it's an arbitrary limit.

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Need help with 8.4 Performance Testing
Next
From: "M. Edward (Ed) Borasky"
Date:
Subject: Re: file system and raid performance