On Thu, Dec 12, 2024 at 10:45:29AM -0500, Andres Freund wrote: > Frankly, we should just move away from using CRCs. They're good for cases > where short runs of bit flips are much more likely than other kinds of errors > and where the amount of data covered by them has a low upper bound. That's not > at all the case for WAL records. It'd not matter too much if CRCs were cheap > to compute - but they aren't. We should instead move to some more generic > hashing algorithm, decent ones are much faster.
Upthread [0], I wondered aloud about trying to reuse the page checksum code for this. IIRC there was a lot of focus on performance when that was added, and IME it catches problems decently well. [0] https://postgr.es/m/ZrUcX2kq-0doNBea%40nathan -- nathan