Changing your huge table's data types in production
- Track: PostgreSQL devroom
- Room: D.postgresql
- Day: Sunday
- Start: 14:30
- End: 15:00
- Video with Q&A: D.postgresql
- Video only: D.postgresql
- Chat: Join the conversation!
![](/2021/schedule/event/postgresql_changing_your_huge_tables_data_types_in_production/postgresql_changing_your_huge_tables_data_types_in_production-cc0cf95d8b74aa2c29dd598dbba5b66a017368fc9752b6f2bc3ca303e99767db.png)
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
![]() |
Jimmy Angelakos |