Về trang chủ

Cách thay đổi các bảng LỚN của bạn mà không làm hỏng production! [#FOSDEM 2021] #PostgreSQL #postgres

vie v3
Tác giả: Jimmy Angelakos
Ngày xuất bản: 2021-02-16T00:00:00
Length: 27:41

📚 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

📚 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

Dịch Vào Lúc: 2025-05-11T12:24:40Z

Yêu cầu dịch (Một bản dịch khoảng 5 phút)

Phiên bản 3 (ổn định)

Tối ưu hóa cho một người nói. Phù hợp cho video chia sẻ kiến thức hoặc giảng dạy.

Video Đề Xuất