Re: [HACKERS] New boxes available for QA

2008-04-07 Thread Decibel!
On Apr 1, 2008, at 7:20 PM, Stephen Frost wrote: * Greg Smith ([EMAIL PROTECTED]) wrote: =4 cores, =8GB RAM, and =8 disks with a usable write-caching controller in it. hrmmm. So a DL385G2, dual-proc/dual-core with 16GB of ram and 8 SAS disks with a Smart Array P800 w/ 512MB of write cache

Re: [HACKERS] New boxes available for QA

2008-04-07 Thread Guillaume Smet
FYI, we (Stefan and I) started a wiki page to organize this effort: http://wiki.postgresql.org/wiki/Performances_QA_testing . Ideas and participation are very welcome. I also described the platform we have here and the usage of each server:

Re: [HACKERS] New boxes available for QA

2008-04-02 Thread Guillaume Smet
On Wed, Apr 2, 2008 at 1:53 AM, Greg Smith [EMAIL PROTECTED] wrote: As far as the other more powerful machines you mentioned go, would need to know a bit more about the disks and disk controller in there to comment about whether those are worth the trouble to integrate. The big missing piece

[HACKERS] New boxes available for QA

2008-04-01 Thread Guillaume Smet
-hackers, As I announced it a couple of months ago, apart from the boxes donated to PostgreSQLFr (affected to the web team IIRC), Continuent also donated 7 servers and a Gb/s switch to us for QA testing. It took some time to set them up but they're now up and running and available. These servers

Re: [HACKERS] New boxes available for QA

2008-04-01 Thread Stephen Frost
Guillaume, * Guillaume Smet ([EMAIL PROTECTED]) wrote: These servers are available 24/7 to PostgreSQL QA and won't be used for other purposes. Awesome. Concerning the second point, I wonder if it's not worth it to have a very simple thing already reporting results as the development cycle

Re: [HACKERS] New boxes available for QA

2008-04-01 Thread Greg Smith
On Tue, 1 Apr 2008, Guillaume Smet wrote: I wonder if it's not worth it to have a very simple thing already reporting results as the development cycle for 8.4 has already started (perhaps several pgbench unit tests testing various type of queries with a daily tree) The pgbench-tools

Re: [HACKERS] New boxes available for QA

2008-04-01 Thread Stephen Frost
* Greg Smith ([EMAIL PROTECTED]) wrote: =4 cores, =8GB RAM, and =8 disks with a usable write-caching controller in it. hrmmm. So a DL385G2, dual-proc/dual-core with 16GB of ram and 8 SAS disks with a Smart Array P800 w/ 512MB of write cache would be helpful? I've got quite a few such

Re: [HACKERS] New boxes available for QA

2008-04-01 Thread Guillaume Smet
On Wed, Apr 2, 2008 at 1:53 AM, Greg Smith [EMAIL PROTECTED] wrote: The pgbench-tools utilities I was working on at one point anticipated this sort of test starting one day. You can't really get useful results out of pgbench without running it enough times that you get average or median

Re: [HACKERS] New boxes available for QA

2008-04-01 Thread Guillaume Smet
On Tue, Apr 1, 2008 at 3:29 PM, Stephen Frost [EMAIL PROTECTED] wrote: I'm almost done scripting up everything to load the TIGER/Line Shapefiles from the US Census into PostgreSQL/PostGIS. Once it's done and working I would be happy to provide it to whomever asks, and it might be an