On 23/05/2024 15:39, Wang Yao wrote:
No obvious perf regression is expected because PG will follow original qsort code path when mksort is disabled. For the case, the only extra cost is the check in tuplesort_sort_memtuples() to enter mksort code path.
And what about the case the mksort is enabled, but it's not effective because all leading keys are different?
-- Heikki Linnakangas Neon (https://neon.tech)