Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

2006-07-29 Thread Charles Sprickman
On Fri, 28 Jul 2006, Mikael Carneholm wrote: Luke, Yeah, I read those results, and I'm very disappointed with my results from the MSA1500. I would however be interested in other people's bonnie++ and benchmarksql results using a similar machine (2 cpu dual core opteron) with other off the

Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

2006-07-29 Thread Luke Lonergan
Charles, FWIW, once our vendor gets all the pieces (having some issues with figuring out which multilane sata cables to get), I'll have a dual-core opteron box with a 3Ware 9500SX-12MI and 8 drives. I need to benchmark to compare this to our xeon/adaptec/scsi build we've been using.

[PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Jochem van Dieten
Tweakers.net has done a database performance test between a Sun T2000 (8 core T1) and a Sun X4200 (2 dual core Opteron 280). The database benchmark is developed inhouse and represents the average query pattern from their website. It is MySQL centric because Tweakers.net runs on MySQL, but Arjen

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Joshua D. Drake
Jochem van Dieten wrote: Tweakers.net has done a database performance test between a Sun T2000 (8 core T1) and a Sun X4200 (2 dual core Opteron 280). The database benchmark is developed inhouse and represents the average query pattern from their website. It is MySQL centric because Tweakers.net

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Arjen van der Meijden
On 29-7-2006 17:43, Joshua D. Drake wrote: I would love to get my hands on that postgresql version and see how much farther it could be optimized. You probably mean the entire installation? As said in my reply to Jochem, I've spent a few days testing all queries to improve their

Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

2006-07-29 Thread Denis Lussier
systems could send me their bonnie + benchmarksql results! I am one of the authors of BenchmarkSQL, it is similar to a DBT2. But, its very easy to use (/or abuse). It's a multithreaded Java Swing client that can run the exact same benchmark (uses JDBC prepared statements) against

Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

2006-07-29 Thread Luke Lonergan
Denis, On 7/29/06 11:09 AM, Denis Lussier [EMAIL PROTECTED] wrote: We do something we call Dynatune at db startup time. Sounds great - where do we download it? - Luke ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Luke Lonergan
Jochem, On 7/29/06 8:02 AM, Jochem van Dieten [EMAIL PROTECTED] wrote: Tweakers.net has done a database performance test between a Sun T2000 (8 core T1) and a Sun X4200 (2 dual core Opteron 280). The database benchmark is developed inhouse and represents the average query pattern from their