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
    1·
    1 year 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.

    • Jason NovingerOPM
      1·
      1 year ago

      I have not yet, but hoping to be able to test it out on some DEV databases soon.