Online / 6 & 7 February 2021

schedule

Changing your huge table's data types in production


You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do?
Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.

Speakers

Photo of Jimmy Angelakos Jimmy Angelakos

Links