Message-ID: <44CB9472.9060206@commandprompt.com>
Date: Sat, 29 Jul 2006 10:01:38 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.4 (X11/20060615)
MIME-Version: 1.0
To: Arjen van der Meijden <acmmailing@tweakers.net>
CC: Jochem van Dieten <jochemd@oli.tudelft.nl>,
	pgsql-performance@postgresql.org
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
References: <44CB7896.8030501@oli.tudelft.nl>
	<44CB8235.9070903@commandprompt.com>
	<44CB8DC1.4040105@tweakers.net>
In-Reply-To: <44CB8DC1.4040105@tweakers.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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/