Re: [GENERAL] Re : Solaris Performance - Profiling (Solved) - Mailing list pgsql-hackers

From mlw
Subject Re: [GENERAL] Re : Solaris Performance - Profiling (Solved)
Date
Msg-id 3CAB1E75.4A66D7E3@mohawksoft.com
Whole thread Raw
In response to Re: [GENERAL] Re : Solaris Performance - Profiling (Solved)  (Justin Clift <justin@postgresql.org>)
List pgsql-hackers
Tom Lane wrote:
> 
> Justin Clift <justin@postgresql.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?


pgsql-hackers by date:

Previous
From: Jessica Perry Hekman
Date:
Subject: Re: timeout implementation issues
Next
From: Tom Lane
Date:
Subject: Re: notification: pg_notify ?