scott.marlowe wrote:
> note that we're talking about a year and a half or so ago, so things may
> have changed under both OSes.
>
> > > The issue in the past was mainly that Solaris had a brain damaged
> > >sort() call that was very slow when it had a lot of duplicate keys. That
> > >has since been updated by Sun.
> > >
> > >
> > Hmm - I ran into that situation with qsort() and many equal keys (see
> > Hackers thread "Solaris Performance"). Sadly Sun have not amended that
> > situation at all (in Solaris 8 anyway).
>
> Actually, I thought there was patch out there somewhere. Anyone else
> know?
qsort() patch is in PostgreSQL 7.3. We used the FreeBSD one for Solaris.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073