News for hackers. Stuff that matters.
Re:Intel Releases x86-SIMD-sort 2.0 With Faster AVX-512 Sort... by cmrdporcupine on Sunday June 25, 2023 @09:44AM (#36468119)
(Hopefully) gone are the days when DBs are spending the bulk of their time blocking in I/O waiting for spinning disks to spin. They spend a lot of intelligence on keeping active tuples paged-in, and memory sizes are exponentially bigger than they used to be, and intelligent query optimization is going to do as much as it can into memory and then apply join algorithms which... are usually sorts.

And even writes, there's sorting there. An LSM or a B-epsilon-tree, etc. they're doing sorting and ordered key traversals before paging out.

There are no comments on this comment yet.