From: Joshua D. Drake <jd@commandprompt.com>
To: Arjen van der Meijden <acmmailing@tweakers.net>
Cc: Jochem van Dieten <jochemd@oli.tudelft.nl>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
Date: Sat, 29 Jul 2006 10:01:38 -0700
Message-ID: <44CB9472.9060206@commandprompt.com> (raw)
In-Reply-To: <44CB8DC1.4040105@tweakers.net>
References: <44CB7896.8030501@oli.tudelft.nl>
<44CB8235.9070903@commandprompt.com>
<44CB8DC1.4040105@tweakers.net>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, acmmailing@tweakers.net, jochemd@oli.tudelft.nl
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
In-Reply-To: <44CB9472.9060206@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox