Postgres 18 defaults to checksums on. This is a good feature for data integrity but might catch you off guard with an upgrade.

CrunchyData's platform is a central hub for PostgreSQL professionals and database administrators, offering insights into PostgreSQL deployment, administration, and optimization. Through articles, tutorials, and case studies, CrunchyData offers insights into PostgreSQL features, replication strategies, and high availability architectures. Readers can learn about database performance tuning, backup and recovery procedures, and security best practices to ensure the reliability and security of their PostgreSQL deployments.

Crunchy Data

PostgreSQL's SERIAL (INT) primary keys risk integer overflow at 2.1 billion rows, but migrating to BIGINT costs virtually nothing due to 8-byte memory alignment. The article provides a complete zero-downtime migration strategy using an atomic swap technique: add a new BIGINT column, backfill data in batches with regular vacuuming, create indexes concurrently, handle foreign key dependencies with NOT VALID constraints, then perform a millisecond metadata swap in a single transaction. Includes production-tested code examples and troubleshooting guidance.

Postgres Serials Should be BIGINT (and How to...

Live data type change in Postgres - the atomic swap