News for hackers. Stuff that matters.
Re:How do databases execute expressions? by adam_oxla on Thursday September 21, 2023 @04:20PM (#37603711)
Amazing overview. Right now I work on a completely new OLAP database: vectorized query execution is must have nowadays if you want to have competitive performance. What's interesting is that vectorized query engines benefits a lot from SIMD instructions (that is obvious). But what is less obvious is that rising popularity of ARM CPUs made it more complex to developer vectorized query engine because one has to provide support for both architectures.
Re:How do databases execute expressions? by gavinray on Thursday September 21, 2023 @05:11PM (#37604419)
Related: "Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask"

https://www.vldb.org/pvldb/vol11/p2209-kersten.pdf

Re:How do databases execute expressions? by eatonphil on Thursday September 21, 2023 @08:35PM (#37606412)
Yep that's a great one. Linked to in the conclusion here as well.
Re:How do databases execute expressions? by yukIttEft on Friday September 22, 2023 @02:26AM (#37608573)
> because one has to provide support for both architectures

You aren't using LLVM IR then? I found that if you are a bit careful, LLVM is perfectly capable to lower IR to vector instructions in ARM/X86 automatically.