-=vyruss=- / blog

  • articles
  • talks
  • tweets
  • blog roll
  • main page

Changing your huge table's data types in production [FOSDEM 2021]

  • Apr 15, 2021
  • 1 min read
  • Categories: talks
  • Tags: #postgresql #fosdem #dba

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.

Video from my short talk at this year's #FOSDEM #PostgreSQL 🐘 devroom 👇

You can find the slides from the talk here.

Tue 27 Apr 2021 12:51:33
Tue 13 Apr 2021 10:33:21
Rendering: Pelican  •  Theme: Peli-Kiera (modified)  •  Copyright © 2025   Jimmy Angelakos