Solaris performance

Err yes...

I said "faster than any Intel I have access to...", I should have said
that the fastest Intel I actually had access to was 2xPIII 500Mhz
running vanilla RedHat 7.1 !

The product I used for testing was DB2 7.2 (which in hindsight may not
be the fairest, as I am told that Solaris is regarded as "one of the
best" DB2 platforms - which I guess may mean "has had a lot of tuning
work done on"...)

With respect to the point I think you are working towards... I would
completely agree... if you can run everything you need on Intel + Linux,
with no performance loss - then dumping Solaris seems like a good idea,
as the cost-effectiveness of Intel vs Sparc cannot be doubted.

(and if your getting performance gains to boot, sounds like a winner to
me)

best wishes

Mark

scratches head ... ] I didn't think there was anything particularly
system-dependent about the sorting code. Have you tried profiling, or
anything to determine where the Solaris version is spending its time?

No... Have not tried these queries again - had some grumpy developers
monstering me about the machine responsiveness...( err what is that
postgres process with 100% of 1 cpu doing ? etc)

I will try profiling the query when they forgive me

regards

Mark

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?

:-)

Regards and best wishes,

Justin Clift

Mark kirkwood wrote:

scratches head ... ] I didn't think there was anything particularly
system-dependent about the sorting code. Have you tried profiling, or
anything to determine where the Solaris version is spending its time?

No... Have not tried these queries again - had some grumpy developers
monstering me about the machine responsiveness...( err what is that
postgres process with 100% of 1 cpu doing ? etc)

I will try profiling the query when they forgive me

regards

Mark

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

On Sun, Feb 10, 2002 at 06:31:13PM +1100, Justin Clift wrote:

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).

It does. Debian has successfully built 7.1.3 on basically every architecture
supported, which include SPARC. Unfortunatly they don't run the regression
tests so it's not clear if all the compiler warnings are meaningless.

http://buildd.debian.org/build.php?arch=&pkg=postgresql

Has anyone ever done decent testing of this?

I just got a SPARC box but it's not configured in any way. If I ever get it
working, I'll try it out.

Anybody else?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/

Martijn van Oosterhout <kleptog@svana.org> writes:

Assuming PostgreSQL runs on Linux on SPARC (can't remember).

It does. Debian has successfully built 7.1.3 on basically every architecture
supported, which include SPARC. Unfortunatly they don't run the regression
tests so it's not clear if all the compiler warnings are meaningless.

http://buildd.debian.org/build.php?arch=&amp;pkg=postgresql

Those warnings look like the same ones I've seen many times on Debian
Alpha. AFAICT they're indicative of nothing except sloppy programming
in a system header file.

I can report that 7.2 passes regression tests on sourceforge's
SPARC/Linux machine, which claims to be Debian 2.2. uname says

Linux usf-cf-sparc-linux-1 2.2.18pre21 #1 SMP Wed Nov 22 17:27:17 EST 2000 sparc64 unknown

Curiously, though, I don't see any of the mathinline warnings on that
machine. Slightly different Debian version perhaps?

regards, tom lane

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@ihs.com> wrote in message
news:a03059a3.0202130819.465f316a@posting.google.com...

justin@postgresql.org (Justin Clift) wrote in message

news:<3C6621C1.85C8479D@postgresql.org>...