Re: PostgreSQL scalability on Sun UltraSparc T1

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

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/