Re :Solaris Performance 
Author Message
 Re :Solaris Performance

In my experience (on Solaris 8 anyway) whether you use gcc or the
SUNWspro cc seems to make little difference...

The problem area I have experienced is that queries that require a
reasonable sort at some point of the plan (e.g have a GROUP BY) will
consume all one 1 cpu (box had 2 of them) for a _very_ long time (e.g.
30 minutes - using either compiler) whereas the same query on a (single
cpu) Intel/Linux takes about 1 minute.

An example is:

SELECT
       d0.f3,
       count(f.val)
FROM dim0 d0,
     fact0 f
WHERE d0.d0key = f.d0key
AND   d0.f1 between '2000-01-01' AND '2000-06-29'
GROUP BY d0.f3

This groups 200000 rows into about 6 buckets.
The "Solaris killer" configuration is where fact0 has 10000000 rows and
dim0 10000.

In general the Solaris box (a 2x450Mhz E220R) is _much_ faster than any
Intels I have access to....

Quote:

>Actually, the first question to ask might be "are you using gcc"?

>It looks to me like s_lock.h/s_lock.c don't have a non-gcc
>implementation of tas() unless you define NEED_SPARC_TAS_ASM
>... which src/include/port/solaris.h doesn't.  Ugh.

regards

Mark

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sat, 24 Jul 2004 17:08:32 GMT
 Re :Solaris Performance

Quote:

> The problem area I have experienced is that queries that require a
> reasonable sort at some point of the plan (e.g have a GROUP BY) will
> consume all one 1 cpu (box had 2 of them) for a _very_ long time (e.g.
> 30 minutes - using either compiler) whereas the same query on a (single
> cpu) Intel/Linux takes about 1 minute.

[ 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?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Sun, 25 Jul 2004 00:58:33 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Re : Solaris Performance - Profiling

2. Re : Solaris Performance - 64 bit puzzle

3. Solaris Performance

4. Re : Solaris Performance - Profiling

5. Re : Solaris Performance - Profiling (Solved)

6. Solaris performance

7. Re^3 : Solaris Performance - 64 bit puzzle

8. Re : Solaris Performance - 64 bit puzzle

9. Re : Solaris Performance - Profiling (Solved)

10. Re : Solaris Performance - 64 bit puzzle

11. Re : Solaris Performance - 64 bit puzzle

12. Re : Solaris Performance - Profiling (Solved)


 
Powered by phpBB® Forum Software