Mark kirkwood <markir@slingshot.co.nz> writes:
> 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