[EPIC] A collection of improvement for the performance for sort and compare and gc, etc

[zhuqi-lucas]

This epic is the collection for improving the performance for sort and compare. cc @Dandandan @alamb

Current sub-tasks:

• Optimize comparison kernels for inlined views #7621
• Clickbench microbenchmark spends significant time in memcmp for not_empty predicate #7766
• Change use of inline_value to inline it to a u128 #7743
• Perf: optimize sort string_view performance #7790
• Improve StringArray(Utf8) sort performance #7847
• Speedup fixed row encoding #7844
• Speedup sorting for inline views: 1.4x - 1.7x improvement #7856
• perf: speed up StringViewArray gc 1.4 ~5.x faster #7873
• Improve the performance for coalese with StringView
• Optimize partition_validity function used in sort kernels #7937
• Perf: Support partition_validity to use fast path for bit map scan #7962

[alamb]

This is pretty amazing @zhuqi-lucas -- love it

[zhuqi-lucas]

I will follow-up adding more subtasks:

Today plan is to experiment:

StringArray sort improvement

[Dandandan]

Nice work @zhuqi-lucas
I plan to look at continuing #7844 somewhere soon-ish.
Might help a bit with the encoding speed of primitives.

[zhuqi-lucas]

Nice work @zhuqi-lucas I plan to look at continuing #7844 somewhere soon-ish. Might help a bit with the encoding speed of primitives.

Interesting improvement @Dandandan !

[zhuqi-lucas]

Added the two sub-tasks now, thanks!

[Dandandan]

Another one #7856

[zhuqi-lucas]

Thank you @Dandandan , added to sub-tasks, and reviewed the PR!

[zhuqi-lucas]

I also including GC improvement for this collection.

Try to add a sub task for gc:

#7873