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

From Mark Kirkwood
Subject Re: qsort (was Re: Solaris)
Date
Msg-id 3EB1E0C9.4040105@paradise.net.nz
Whole thread Raw
In response to Re: qsort (was Re: Solaris)  (Mark Kirkwood <markir@paradise.net.nz>)
Responses Re: qsort (was Re: Solaris)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: qsort (was Re: Solaris)
Next
From: "Don V. Soledad"
Date:
Subject: translate function