Re: PostgreSQL and Ultrasparc T1

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)
whichslowed me down (10K rpm 146 GB disks FC) with 4 LUNS going through a longer pass to the disks (via a controller
masterarray 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
bottleneckon 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
generatedusing 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
>