Re: qsort again (was Re: [PERFORM] Strange Create

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron <rjpeace@earthlink.net>
Cc: Martijn van Oosterhout <kleptog@svana.org>, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org
Date: 2006-02-16T16:20:23Z
Lists: pgsql-hackers, pgsql-performance
Ron <rjpeace@earthlink.net> writes:
> Your cost comment basically agrees with mine regarding the cost of 
> random memory accesses.  The good news is that the number of datums 
> to be examined during the pivot choosing process is small enough that 
> the datums can fit into CPU cache while the pointers to them can be 
> assigned to registers: making pivot choosing +very+ fast when done correctly.

This is more or less irrelevant given that comparing the pointers is not
the operation we need to do.

			regards, tom lane