News for hackers. Stuff that matters.
Re:ULIDs and Primary Keys by erik_seaberg on Friday April 12, 2024 @06:14PM (#40018221)
The way to take advantage of the bandwidth of multiple storage devices is to distribute concurrent writes across them, rather than forcing everything to commit sequentially using contended locks or rollbacks.
Re:ULIDs and Primary Keys by sgarland on Saturday April 13, 2024 @07:59AM (#40022551)
The DB (or any application) should not have any need to know what devices are underneath its mount point. If you’re striping across disks, that’s a device (or filesystem, for ZFS) level implementation.