v0.5.0-M1
Highlights
This release brings major change for journals partitioned by ordering
values. (persistence_id, sequence_number)
index is now unique and can be (re)built without taking any locks that prevent concurrent inserts, updates, or deletes on the table. In other words migration can be lockless.
See full list of changes: https://github.com/SwissBorg/akka-persistence-postgres/milestone/7?closed=1
Migration from akka-persistence-postgres 0.4.0
New indices need to be created on each partition, to avoid locking production databases for too long, it should be done in 2 steps:
- manually create indices CONCURRENTLY,
- deploy new release with migration scripts.
Manually create indices CONCURRENTLY
Execute DDL statements produced by the sample migration script, adapt top level variables to match your journal configuration before executing.
Deploy new release with migration scripts
See sample flyway migration script and adapt top level variables to match your journal configuration.