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