Re: qsort (was Re: Solaris) - Mailing list pgsql-general

From Dennis Gearon
Subject Re: qsort (was Re: Solaris)
Date
Msg-id 3EB1FDC4.5191D826@cvc.net
Whole thread Raw
In response to Re: qsort (was Re: Solaris)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: qsort (was Re: Solaris)  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-general
The trend has been approx:

    On Linux
        BSD qsort is 30-55% faster on average.
    On Non Liux
        BSD qsor it 50-90% on average.

This kind of says that Linux is doing something right in the kernal,
outdoing mainframe software in this sort of thing.

Mark Kirkwood wrote:
>
> I prevailed on some friends to try out a non Redhat distro plus HPUX 10.20 :
>
> 1 United Linux 1.0 (x86 Linux 2.4.19 )
>
> Value (i = index)       BSD      GLIBC (seconds)
> random() * mod          0.35     0.56
> i % mod                 0.14     0.41
> i / (ITEMS / mod)       0.10     0.27
> i ^ 0x5555555           0.26     0.42
>
> 2 HPUX 10.20 (pa-risc1.1 D380 )
>
> Value (i = index)       BSD      HPUX (seconds)
> random() * mod          8.3      14.0
> i % mod                 2.9      4.9
> i / (ITEMS / mod)       2.4      2.9
> i ^ 0x5555555           7.8      13.8
>
> The HPUX results are interesting !
>
> regards
>
> Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: Updating a table which is null doesn't work? (fwd)
Next
From: Tom Lane
Date:
Subject: Re: qsort (was Re: Solaris)