~/talk

Changing your huge table's data types in production

Talkat FOSDEM 2021 · on Sunday, 2021-02-07· at 14:30· D.postgresql· [databases]

speaker

name:Jimmy Angelakos

website:http://hubs.la/Q03Nc0hv0

resources

video:https://video.fosdem.org/2021/D.postgresql/postgresql_changing_your_huge_tables_data_types_in_production.mp4

slides:https://fosdem.org/2021/schedule/event/postgresql_changing_your_huge_tables_data_types_in_production/attachments/slides/4718/export/events/attachments/postgresql_changing_your_huge_tables_data_types_in_production/slides/4718/changing_data_types_in_prod.pdf

summary

Shows a method for changing a column's data type on a very large, live database table without downtime by avoiding long DDL locks. The approach uses procedural transaction control (e.g., application-side or DB procedural code) to perform the conversion in an unobtrusive, incremental way while the table continues serving users.

AI-written summary · about

related talks