0039_unique_series_references migration needs optimization

[Stephen Finucane]

On Wed, 2020-10-14 at 11:06 +1100, Daniel Axtens wrote:
> Hi Konstantin,
> 
> > Would adding an index across (id, project_id, msgid) make this query 
> > faster to run?
> 
> Thanks for the report, and once again our apologies that we don't have
> good test setups for large data sets.
> 
> I think jk reported a slow migration as well but I think it might have
> been a different one? We should fix both for stable/2.2.
> 
> Stephen, did we squash all of these for 3.0 or should we fix them on
> master also?

Nothing is squashed yet, iirc, so this can go to master and be
backported. Definitely worth fixing too. I'm going to be slammed for
the next week and a half or so (virtual conferences) but I could take a
look after that. No issues with a fix being worked on in my absence
either :)

Stephen

> Kind regards,
> Daniel
> 
> > -K
> > _______________________________________________
> > Patchwork mailing list
> > Patchwork at lists.ozlabs.org
> > https://lists.ozlabs.org/listinfo/patchwork
> _______________________________________________
> Patchwork mailing list
> Patchwork at lists.ozlabs.org
> https://lists.ozlabs.org/listinfo/patchwork