General Operations Tips
Tips to improve performances or to cover some corner use cases.
Conditional execution date2serial migration
In FactCast v0.7.1, a new UI feature was introduced to allow filtering of events based on their publishing date. For
this purpose, the date2serial
mapping table was introduced in the schema.
A Liquibase changeset takes care of creating and populating the date2serial
table, but it is not executed when the
store contains more than 10 million events. This is to prevent the migration from taking too long on larger setups.
As mentioned in the changeset comments, it is suggested to run the changeset manually in such cases. The changeset can
be found in the factcast-store
module under src/main/resources/db/changelog/factcast/issue2479/date2serial_for_existing_events.sql
.
Last modified
March 12, 2025
: shuffled the tips around (88a9f4b56)