Re: Solaris Performance - Mailing list pgsql-general

From Tom Lane
Subject Re: Solaris Performance
Date
Msg-id 12313.1012857133@sss.pgh.pa.us
Whole thread Raw
In response to Re: Solaris Performance  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
List pgsql-general
"P.J. \"Josh\" Rovero" <rovero@sonalysts.com> writes:
> For non-postgresql applications, the Suns are
> typically faster than the HPs.  While direct
> comparisons are always dangerous, the SPARC
> chips are clocked at about 2-3 times what
> the PA-RISC chips are.

> The postgresql performance on Solaris is
> an order of magnitude (10x) slower than
> Linux x86 at same CPU clock speed.

Hmm.  So can you figure out where the time is going?  What do you see
with top, iostat, vmstat, ...?  Can you recompile with profiling (gmake
clean, gmake PROFILE=-pg all typically works on gcc platforms) and learn
something about where the backend is spending its time?

            regards, tom lane

pgsql-general by date:

Previous
From: "P.J. \"Josh\" Rovero"
Date:
Subject: Re: Solaris Performance
Next
From: Bruce Momjian
Date:
Subject: Re: Solaris Performance