S2024 #06 - Vectorized Query Execution Using SIMD (CMU Advanced Database Systems)

Andy Pavlo (www.cs.cmu.edu...)
Slides: 15721.courses....
Notes: 15721.courses....
15-721 Advanced Database Systems (Spring 2024)
Carnegie Mellon University
15721.courses....

[@fexolm]

Hey Andy! Thank you for your awesome content! BTW could you share the links to the papers you give to your students? Would really appreciate that!

[@felixmilner8410]

See course link above in the description

[@fexolm]

Oh, found them, thanks! For others like me, they are in schedule section.

[@LtdJorge]

AMD doesn’t downclock on AVX-512, they took their time to support it but did it right (it was a double pump design at first with dual 256 bit registers and a 512 one now). I think Intel doesn’t downclock mow, or at least not as bad (it was really bad, read on Cloudflare blog when used for terminating TLS), but their support for it is somewhat worse than AMD’s. Also AVX-512 is super fragmented :(

[@oneofpro]

thanks