Re: [GENERAL] Re : Solaris Performance - Profiling (Solved)

Tom Lane wrote:
>
> Justin Clift <justin(at)postgresql(dot)org> writes:
> > Mark kirkwood wrote:
> >> Indeed it is - obtained qsort.c from Freebsd CVS and rebuilt Postgresql :
> >> The query now takes 6 seconds instead of 1 hour ! Thanks for an
> >> excellent suggestion.
>
> > How about we include this and have configure somehow ensure the Solaris
> > users get it automatically?
>
> > There are a *bunch* of Solaris users out there.
>
> Hmm. I suppose there'd be no license issues with borrowing a BSD qsort.
> But I can't see any reasonable way for configure to decide automatically
> whether we should replace the system qsort. I think we'd have to put
> a USE_PRIVATE_QSORT symbol definition into src/template/solaris.
>
> Can anyone see a problem with doing it that way --- are there any
> versions of Solaris where this'd be a bad idea?

I noticed poor performance on Solaris, does one see this problem when compiling
PostgreSQL with gcc on solaris?

As a suggestion, why not find the *best* version of qsort available, anywhere,
and always use that version on all platforms?