On Sat, 17 Dec 2005, Dann Corbit wrote:
> > The benchmarks say that they (order checks) are a good idea on average > for ordered data, random data, and partly ordered data. > I interpret that in linux, 5000000 seems a divide for qsortpdq. Before that number, it wins, after that, bsd wins more. On SunOS, qsortpdq takes the lead till the last second -- I suspect this is due to the rand() function: Linux - #define RAND_MAX 2147483647 SunOS - #define RAND_MAX 32767 So in SunOS, the data actually not that scattered - so more favourate for sorted() or reversed() check? Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org