How to change your HUGE tables without breaking production! [#FOSDEM 2021] #PostgreSQL #postgres

📚 PostgreSQL Mistakes and How to Avoid Them: https://mng.bz/vKd4

Follow me on:

🦣 https://fosstodon.org/@vyruss

🦋 https://bsky.app/profile/vyruss.org

https://www.linkedin.com/in/vyruss/

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.

Talk from the PostgreSQL devroom at FOSDEM 2021

Slides: https://www.slideshare.net/vyruss000/changing-your-huge-tables-data-types-in-production