Re:Fastest table sort in the West – Redesigning DuckDB's sort
by AdamProut on Friday August 27, 2021 @06:21PM
(#28333589)
Did any of the actual benchmark queries in TPC-H or TPC-DS show a speed up?
My intuition is that the performance of large sorts (100 millions of rows) are not that important for most analytical workloads compared to the performance of doing scans, group-bys and joins. Top-sorts (ORDER BY X LIMIT N) are much more popular, but most databases use different algorithms for those.
My intuition is that the performance of large sorts (100 millions of rows) are not that important for most analytical workloads compared to the performance of doing scans, group-bys and joins. Top-sorts (ORDER BY X LIMIT N) are much more popular, but most databases use different algorithms for those.