search

mautrix / signal

A Matrix-Signal puppeting bridge
GNU Affero General Public License v3.0
499 stars 75 forks source link

DB migration fixes #451

Closed AndrewFerr closed 7 months ago

AndrewFerr commented 7 months ago

This fixes some potential failures on migrating the main store to v16.

AndrewFerr commented 7 months ago

ea9fc29 isn't strictly necessary, but it unblocked an extremely slow migration (>14 hours) on a big database & may come in handy for others.

I also haven't tested d9b139a but assume it's no different from the Postgres case.

tulir commented 7 months ago

Cascades aren't slow, it's probably just missing some indexes

AndrewFerr commented 7 months ago

Cascades aren't slow, it's probably just missing some indexes

Alright, that makes more sense. In any case, I couldn't find the right index to add that made the cascade any faster. An index would be ideal, though.