Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-08-07 Thread Arjen van der Meijden
Hi Markus, As said, our environment really was a read-mostly one. So we didn't do much inserts/updates and thus spent no time tuning those values and left them as default settings. Best regards, Arjen Markus Schaber wrote: Hi, Arjen, Arjen van der Meijden wrote: It was the 8core version

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-08-07 Thread Markus Schaber
Hi, Arjen, Arjen van der Meijden wrote: > It was the 8core version with 16GB memory... but actually that's just > overkill, the active portions of the database easily fits in 8GB and a > test on another machine with just 2GB didn't even show that much > improvements when going to 7GB (6x1G, 2x 51

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-08-01 Thread Arjen van der Meijden
On 1-8-2006 19:26, Jim C. Nasby wrote: On Sat, Jul 29, 2006 at 08:43:49AM -0700, Joshua D. Drake wrote: I'd love to get an english translation that we could use for PR. Actually, we have an english version of the Socket F follow-up. http://tweakers.net/reviews/638 which basically displays the

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-08-01 Thread Jim C. Nasby
On Sat, Jul 29, 2006 at 08:43:49AM -0700, Joshua D. Drake wrote: > 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 qu

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-31 Thread Merlin Moncure
On 7/29/06, 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 website. It is MySQ

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-31 Thread Arjen van der Meijden
Hi Jignesh, It was a cvs-checkout of 8.2 devel, compiled using: CPPFLAGS="-fast -xtarget=ultraT1 -xnolibmopt" CC=/opt/SUNWspro/bin/cc ./configure --without-readline We'd gotten a specially adjusted Solaris version from Sun Holland for the T2000. It was a dvd with a Solaris flar archive from 1

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-31 Thread Jignesh Shah
Hi Arjen, I am curious about your Sun Studio compiler options also. Can you send that too ? Any other tweakings that you did on Solaris? Thanks. Regards, Jignesh Arjen van der Meijden wrote: On 29-7-2006 19:01, Joshua D. Drake wrote: Well I would be curious about the postgresql.conf and how

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

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Arjen van der Meijden
On 29-7-2006 19:01, Joshua D. Drake wrote: Well I would be curious about the postgresql.conf and how much ram etc... it had. It was the 8core version with 16GB memory... but actually that's just overkill, the active portions of the database easily fits in 8GB and a test on another machine wit

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Joshua D. Drake
Arjen van der Meijden wrote: 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

Re: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1

2006-07-29 Thread Arjen van der Meijden
On 29-7-2006 17:02, 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 be

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 performance

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 r

[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 va