v0.5.0

What's Changed

• Share some preliminary load test figures in #54
• Reuse existing transaction open for reading table columns in #53
• Start to deprecate --password with PGPASSWORD in #56
• Introduce configurable PULL_BATCH_COUNT and DELTA_COUNT in #57

Full commits: v0.4.0...v0.5.0
Changelog: https://github.com/shayonj/pg-online-schema-change/blob/main/CHANGELOG.md
DockerHub: https://hub.docker.com/r/shayonj/pg-osc

v0.4.0

What's Changed

• Lint sourcecode, setup Rubocop proper and Lint in CI in #46
• Uniquely identify operation_type column in #50
• Introduce primary key on audit table for ordered reads in #49
  • This addresses an edge case with replay.
• Uniquely identify trigger_time column by in #51
• Abstract assertions into a helper function by in #52

Full commits: v0.3.0...v0.4.0
Changelog: https://github.com/shayonj/pg-online-schema-change/blob/main/CHANGELOG.md
DockerHub: https://hub.docker.com/r/shayonj/pg-osc

v0.3.0

What's Changed

• Explicitly call dependencies and bump dependencies #44
• Introduce Dockerfile and release process #45

Full commits: v0.1.0...v0.2.0
Changelog: https://github.com/shayonj/pg-online-schema-change/blob/main/CHANGELOG.md
DockerHub: https://hub.docker.com/r/shayonj/pg-osc

v0.2.0

What's Changed

• Use ISOLATION LEVEL SERIALIZABLE by @shayonj, @jfrost in #42

Full commits: v0.1.0...v0.2.0
Changelog: https://github.com/shayonj/pg-online-schema-change/blob/main/CHANGELOG.md

v0.1.0

What's Changed

Initial release

pg-online-schema-change (pg-osc) is a tool for making schema changes (any ALTER statements) in Postgres tables with minimal locks, thus helping achieve zero downtime schema changes against production workloads.

pg-osc uses the concept of shadow table to perform schema changes. At a high level, it copies the contents from a primary table to a shadow table, performs the schema change on the shadow table and swaps the table names in the end while preserving all changes to the primary table using triggers (via audit table).

Checkout Readme for more details.

Contributors

• @shayonj (author)
• @lingrino made their first contribution in #4
• @jfrost made their first contribution in #34

Full commits: https://github.com/shayonj/pg-online-schema-change/commits/v0.1.0
Changelog: https://github.com/shayonj/pg-online-schema-change/blob/main/CHANGELOG.md