From: Jignesh Shah <J.K.Shah@Sun.COM>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Juan Casero <caseroj@comcast.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Ultrasparc T1
Date: Mon, 19 Dec 2005 15:21:06 -0500
Message-ID: <fcc4f7c276bc.43a6cfe2@sun.com> (raw)
In-Reply-To: <BFCC4BEB.16CE3%llonergan@greenplum.com>
References: <f7b2838476ad.43a6c3e6@sun.com>
<BFCC4BEB.16CE3%llonergan@greenplum.com>
Hi Luke,
I got about 720 MB/sec to 730 MB/sec with plain dd tests on my current storage configuration (8 LUNS on 4 fibers) which slowed me down (10K rpm 146 GB disks FC) with 4 LUNS going through a longer pass to the disks (via a controller master array to slave JBODs to provide ) .
extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
0.8 14.0 0.0 0.0 0.0 0.3 0.0 17.8 0 4 c3t0d0
91.4 0.0 91.4 0.0 0.0 1.0 0.0 10.5 0 96 c0t40d0
96.0 0.0 96.0 0.0 0.0 1.0 0.0 10.0 0 96 c5t40d1
95.8 0.0 95.8 0.0 0.0 1.0 0.0 10.0 0 96 c0t40d1
96.8 0.0 96.8 0.0 0.0 1.0 0.0 9.9 0 96 c5t40d0
84.6 0.0 84.6 0.0 0.0 1.0 0.0 11.4 0 96 c4t46d1
85.6 0.0 85.6 0.0 0.0 1.0 0.0 11.2 0 96 c4t46d0
85.2 0.0 85.2 0.0 0.0 1.0 0.0 11.3 0 96 c2t46d1
85.4 0.0 85.4 0.0 0.0 1.0 0.0 11.3 0 96 c2t46d0
I can probably bump it up a bit with fine storage tuning (LUN) but there is no limitation on the Sun Fire T2000 to bottleneck on anything plus dd tests are not the best throughput measurement tool.
Yes UltraSPARC T1 supports the SPARC V9 architecture and can support all the SPARC binaries already generated or newly generated using gcc or Sun Studio 11 which is also free.
http://developers.sun.com/prodtech/cc/downloads/sun_studio/
Regards,
Jignesh
----- Original Message -----
From: Luke Lonergan <llonergan@greenplum.com>
Date: Monday, December 19, 2005 2:38 pm
Subject: Re: [PERFORM] PostgreSQL and Ultrasparc T1
To: Jignesh Shah <J.K.Shah@Sun.COM>
Cc: Juan Casero <caseroj@comcast.net>, pgsql-performance@postgresql.org
> Jignesh,
>
> On 12/19/05 11:29 AM, "Jignesh Shah" <J.K.Shah@Sun.COM> wrote:
>
> > I have gone to the max with 4 fibers on Sun Fire T2000. But I am
> not sure
> > about the answers that you asked. Let me see if I can get answers
> for them. I
> > am going to try to max out the IO on these systems with 8 fibers
> as soon as I
> > get additional storage so stay tuned for that.
>
> Cool - how close did you get to 800MB/s?
>
> > By the way you don't have to wait for my tests. Just get a trial
> server and
> > try it on your own. If you don't like it return it.
> >
> > https://www.sun.com/emrkt/trycoolthreads/contactme.html
>
> Done - I'll certainly test Postgres / Bizgres on it - you know me ;-)
>
> > However if you do try it with PostgreSQL, do let me know also
> with your
> > experience.
>
> See above.
>
> The Niagara is UltraSparc III compatible - so the GCC compiler
> should emit
> good code for it, right?
>
> - Luke
>
>
>
> ---------------------------(end of broadcast)-----------------------
> ----
> TIP 2: Don't 'kill -9' the postmaster
>
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: J.K.Shah@Sun.COM, llonergan@greenplum.com, caseroj@comcast.net
Subject: Re: PostgreSQL and Ultrasparc T1
In-Reply-To: <fcc4f7c276bc.43a6cfe2@sun.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