offline for upgrade - Mon 13 April

Jeremy Kerr jk at
Mon Apr 13 17:15:42 AEST 2020

Hi all,

> 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
> done.

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 mailing list