We've got tables with columns of data type NUMERIC(38,0) which are a legacy from an Oracle migration.
Besides what's mentioned in https://www.postgresql.org/docs/12/ddl-alter.html#id-1.5.4.8.10, what happens internally when I run:
ALTER TABLE foo ALTER COLUMN bar TYPE BIGINT;
I'm thinking mostly of record fragmentation.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.