Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL - GitHub - shayonj/pg-osc: Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

⚠ Proceed with caution when using this on production like workloads. Best to try on similar setup or staging like environment first. Read on below for some examples and caveats.

  • msage@programming.dev
    1·
    2 years ago

    Anyone tried this?

    I’ve been using Percona Online Schema Change in MySQL, and that works great… until it renames a big table that needs to be fully in memory, and every query waits for the disk reads.

    But I’m not sure anyone can deal with that.