Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL scalability on Sun UltraSparc T1

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
Cc: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
Date: 2006-07-29 17:01:38
Message-ID: 44CB9472.9060206@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 to improve their 
> performance. I'm not sure what kind of improvements that yielded, but if 
> I remember correctly its in the order of 3-5 times for the entire 
> benchmark, compared to the initial MySQL-layout and queries.
> 
> If you mean the configuration and which version it was, I can look that 
> up for you if you'd like. Including the compilation switches used on the 
> T2000.

Well I would be curious about the postgresql.conf and how much ram 
etc... it had.

> Then again, we regularly have other server hardware on which the same 
> database is used, so even without the T2000 we could still do some 
> effort to further improve postgresql's performance.
> It might be interesting to have some Postgres experts do some more 
> tuning and allowing MySQL AB to do the same... But I'm not sure if we're 
> willing to spent that much extra time on a benchmark (just testing one 
> database costs us about a day and a half...)

I understand, I just have a feeling that we could do even better :) I do 
appreciate all your efforts.

Sincerely,

Joshua D. Drake


> 
> Best regards,
> 
> Arjen
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



In response to

Responses

pgsql-performance by date

Next:From: Arjen van der MeijdenDate: 2006-07-29 17:39:30
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
Previous:From: Arjen van der MeijdenDate: 2006-07-29 16:33:05
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group