patchwork.ozlabs.org offline for upgrade - Mon 13 April
jk at ozlabs.org
Mon Apr 13 17:15:42 AEST 2020
> I see that there are a couple of large migrations in the 2.2.0 release,
> but hopefully they won't take too long. I'll send an update when we're
OK, we're back up and running on v2.2.0. Let me know if you see
anything odd post-upgrade.
A couple of notes:
- by far the longest migration task was executing these queries:
looks like that would be a good contender for an UPDATE .. FROM,
rather than the ~2 million subqueries
- the database disk usage has increased by about 14%; I assume this is
the new indexes.
That said, all went pretty smoothly, given the python & django upgrades
required too. Thanks patchworkers, and thanks to sfr for the help!
More information about the Patchwork