Re: [HACKERS] Test lab

2007-11-23 Thread Simon Riggs
On Thu, 2007-11-22 at 22:29 +, Heikki Linnakangas wrote: > Simon Riggs wrote: > > > > I'm thinking of some performance regression testing to see what else is > > lurking around the corner for us. > > If you have something you can just throw over the fence, I can run stuff > on Imola as well.

Re: [HACKERS] Test lab

2007-11-22 Thread Heikki Linnakangas
Simon Riggs wrote: On Thu, 2007-11-08 at 13:34 -0800, Joshua D. Drake wrote: On Sun, 04 Nov 2007 18:55:59 + Simon Riggs <[EMAIL PROTECTED]> wrote: ve up and have ready access to is a HP DL 585. It has 8 cores (Opteron), 32GB of ram and 28 spindles over 4 channels. My question is -hackers,

Re: [HACKERS] Test lab

2007-11-22 Thread Simon Riggs
On Thu, 2007-11-08 at 13:34 -0800, Joshua D. Drake wrote: > On Sun, 04 Nov 2007 18:55:59 + > Simon Riggs <[EMAIL PROTECTED]> wrote: > ve up and have ready access to > > > is a HP DL 585. It has 8 cores (Opteron), 32GB of ram and 28 > > > spindles over 4 channels. > > > > > > My question is -ha

Re: [HACKERS] Test lab

2007-11-09 Thread Greg Smith
On Sun, 4 Nov 2007, Stefan Kaltenbrunner wrote: I never got the database tests in SysBench to produce useful results [because of deadlocks] hmm I have not seen that and the recent freebsd related scalability benchmarks(http://people.freebsd.org/~kris/scaling/) seem to indicate that it seems t

Re: [HACKERS] Test lab

2007-11-08 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 04 Nov 2007 18:55:59 + Simon Riggs <[EMAIL PROTECTED]> wrote: ve up and have ready access to > > is a HP DL 585. It has 8 cores (Opteron), 32GB of ram and 28 > > spindles over 4 channels. > > > > My question is -hackers, is who wants first

Re: [HACKERS] Test lab

2007-11-08 Thread Simon Riggs
On Sun, 2007-11-04 at 18:55 +, Simon Riggs wrote: > On Fri, 2007-11-02 at 10:42 -0700, Joshua D. Drake wrote: > > > > My question is -hackers, is who wants first bite and what do they > > want :) > > I'll take a few slots, probably 3 x 1 days, at least a week apart. Won't > be able to start

Re: [HACKERS] Test lab

2007-11-08 Thread Josh Berkus
Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, The test lab is finally starting to come to fruition. We (the community) have been donated hardware via MyYearbook and Hi5. It is my understanding that we may also have some coming from HP. Also, from Sun, and from I

Re: [HACKERS] Test lab

2007-11-07 Thread Greg Smith
On Wed, 7 Nov 2007, Hannu Krosing wrote: To be really useful, we should always run general system monitoring alongside DB test runs, so we can see, and also later look up, where the bottleneck are. The way the DBT-2 tests run involves spawning off the relevant monitoring tools (iostat, vmstat

Re: [HACKERS] Test lab

2007-11-07 Thread Hannu Krosing
Ühel kenal päeval, P, 2007-11-04 kell 13:02, kirjutas Greg Smith: > On Sat, 3 Nov 2007, Stefan Kaltenbrunner wrote: > > > there is the various dbt workloads,sysbench, jans tpc-w implementation, > > hell even pgbench > > The DBT workloads are good for simulating disk-bound operations, but I > d

Re: [HACKERS] Test lab

2007-11-06 Thread Guillaume Smet
Hi Robert (small world, I contributed to Sequoia a while ago...), all, On 11/6/07, Robert Hodges <[EMAIL PROTECTED]> wrote: > 2.) Test hardware. We have a number of hosts in Grenoble, France that are > available to help set up a European lab.We gave away 4 to the > postgresql.fr folks but if

Re: [HACKERS] Test lab

2007-11-06 Thread Robert Hodges
Hi everyone, Here are a couple of additions to the performance test lab discussion. I hope you will find these useful. 1.) Test tools. The Bristlecone testing package I presented at the PG Fall 2007 Conference is now available at http:// bristlecone.continuent.org. There are two main t

Re: [HACKERS] Test lab

2007-11-06 Thread Mark Wong
On Tue, 06 Nov 2007 13:15:02 + Simon Riggs <[EMAIL PROTECTED]> wrote: > On Mon, 2007-11-05 at 14:33 -0800, Mark Wong wrote: > > On 11/4/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > > > Why don't you post a TODO list for TPC-E somewhere, so people can bite > > > small pieces off of the li

Re: [HACKERS] Test lab

2007-11-06 Thread Simon Riggs
On Mon, 2007-11-05 at 14:33 -0800, Mark Wong wrote: > On 11/4/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > Why don't you post a TODO list for TPC-E somewhere, so people can bite > > small pieces off of the list. I'm sure there's lots of people can help > > if we do it that way. > > This shou

Re: [HACKERS] Test lab

2007-11-05 Thread Mark Wong
On 11/4/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > Mark, > > Why don't you post a TODO list for TPC-E somewhere, so people can bite > small pieces off of the list. I'm sure there's lots of people can help > if we do it that way. This should be a good start: http://osdldbt.sourceforge.net/dbt5/t

Re: [HACKERS] Test lab

2007-11-04 Thread Stefan Kaltenbrunner
Greg Smith wrote: > On Sat, 3 Nov 2007, Stefan Kaltenbrunner wrote: > >> there is the various dbt workloads,sysbench, jans tpc-w >> implementation, hell even pgbench > > The DBT workloads are good for simulating disk-bound operations, but I > don't think they're sufficient by themselves for detec

Re: [HACKERS] Test lab

2007-11-04 Thread Simon Riggs
On Fri, 2007-11-02 at 10:42 -0700, Joshua D. Drake wrote: > The test lab is finally starting to come to fruition. We (the > community) have been donated hardware via MyYearbook and Hi5. It is my > understanding that we may also have some coming from HP. > > We are currently setting up a Trac for

Re: [HACKERS] Test lab

2007-11-04 Thread Simon Riggs
On Fri, 2007-11-02 at 17:25 -0700, Mark Wong wrote: > On Fri, 02 Nov 2007 15:20:27 -0400 > Tom Lane <[EMAIL PROTECTED]> wrote: > > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > > My question is -hackers, is who wants first bite and what do they > > > want :) > > > > Something I'd like to h

Re: [HACKERS] Test lab

2007-11-04 Thread Greg Smith
On Sat, 3 Nov 2007, Stefan Kaltenbrunner wrote: there is the various dbt workloads,sysbench, jans tpc-w implementation, hell even pgbench The DBT workloads are good for simulating disk-bound operations, but I don't think they're sufficient by themselves for detecting performance regressions

Re: [HACKERS] Test lab

2007-11-03 Thread Stefan Kaltenbrunner
Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: >> My question is -hackers, is who wants first bite and what do they >> want :) > > Something I'd like to have back real soon is the daily DBT run against > CVS HEAD that Mark Wong was doing at OSDL. Maybe we don't need a > particul

Re: [HACKERS] Test lab

2007-11-02 Thread Mark Wong
On Fri, 02 Nov 2007 15:20:27 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > My question is -hackers, is who wants first bite and what do they > > want :) > > Something I'd like to have back real soon is the daily DBT run against > CVS HEAD that Mark

Re: [HACKERS] Test lab

2007-11-02 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > My question is -hackers, is who wants first bite and what do they > want :) Something I'd like to have back real soon is the daily DBT run against CVS HEAD that Mark Wong was doing at OSDL. Maybe we don't need a particularly enormous machine for th

[HACKERS] Test lab

2007-11-02 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, The test lab is finally starting to come to fruition. We (the community) have been donated hardware via MyYearbook and Hi5. It is my understanding that we may also have some coming from HP. We are currently setting up a Trac for management and