PSA: Since PostgreSQL 14, there is optional support for checksumming data-pages. You can - and probably should - enable that, although it's an offline operation that will take some time for larger databases. It might just save your butt if you have to deal with corrupted data (especially subtle things like silent data corruption due to a broken storage device).

For #podmins who are concerned about potential performance issues: don't be. I enabled it on January 17th, and there does not appear to be any relevant difference in my metrics.

There are no comments yet.