I'm running PostgreSQL on a Sun Ultra 60 running Solaris 8. It's maybe not
a fair comparison, as before I was running everything
(JBoss/TomCat/Apache/PostgreSQL) on a 550MHz Pentium with 384M of RAM, and a
single 7200 RPM IDE drive, but I got a real big boost in performance when I
moved PosgreSQL onto the Solaris box. It seems like a pretty good platform
for PosgreSQL, and I would think the 10K drives would speed things up a bit.
But I'm no expert.
Kelly McTiernan
"Scott Marlowe" <smarlowe(at)ihs(dot)com> wrote in message
news:a03059a3(dot)0202130819(dot)465f316a(at)posting(dot)google(dot)com(dot)(dot)(dot)
> justin(at)postgresql(dot)org (Justin Clift) wrote in message
news:<3C6621C1(dot)85C8479D(at)postgresql(dot)org>...
> > Just had a thought,
> >
> > It would be interesting to know how PostgreSQL performs on Linux on
> > SPARC, compared to how it performs on Solaris on SPARC.
> >
> > Assuming PostgreSQL runs on Linux on SPARC (can't remember).
> >
> > Has anyone ever done decent testing of this?
>
> A buddy of mine at work and I did. I put my Sparc20 with 512 Meg RAM
> against his Ultra 1 with 256 megs of RAM. I was running a single 2
> Gig Barracuda drive with narrow SCSI and he was running a 5 to 10 Gig
> ide drive. My Sparc 20 was running RedHat 6.2 and his was running the
> latest and greatest version of Solaris at the time last fall. Both
> machines had compiled postgresql 7.1.2 or 7.1.3, whichever was out
> then with gcc.
>
> My Sparc 20 was a match for the Ultra 1 for every query we threw at
> them. Sometimes a little slower, mostly a little faster.
>
> I'd like to get the time to put Linux and Solaris dual boot on an
> Ultra 60 or something and get some real numbers, but our little test
> convinced me that Linux is a much better platform for Postgresql than
> Solaris.
>
> I've heard similar stories re: BSD performance being much worse than
> Linux for postgresql but haven't had any chance to do any testing.
>
> My thanks to all the postgresql developers, we love you man! :-)
>
> Scott Marlowe