News for hackers. Stuff that matters.

A comment on Zero-downtime schema migrations in Postgres using Reshape.

Re:Zero-downtime schema migrations in Postgres using Reshape by shayonj on Friday January 07, 2022 @07:56AM (#29838562)
This is very interesting, thanks for sharing. I had been noodling on the concept of zero downtime schema changes in postgres as well, and recently started https://github.com/shayonj/pg-online-schema-change. Its inspired by pg_repack and pt-online-schema-change (mysql).

I will give this a spin! Kudos

[ Parent | on HN ]
Re:Zero-downtime schema migrations in Postgres using Reshape by fabianlindfors on Friday January 07, 2022 @08:28AM (#29838813)
That's really cool, thanks for sharing! I've also considered using shadow tables but haven't needed them yet. Might change in the future. I really like how your solution allows one to user regular DDL statements and not some DSL.

Let me know if you run into any bugs :)

[ Parent | on HN ]