0039_unique_series_references migration needs optimization

Daniel Axtens dja at axtens.net
Thu Oct 22 10:24:35 AEDT 2020


Stephen Finucane <stephen at that.guru> writes:

> 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 :)

hah - I'll see if I have a moment, things are crazy here too! It seems
distros have this weird desire to get code delivered to them well in
advance of their scheduled releases so they can do this odd 'test' thing
they're apparently quite keen on :P

 -- d

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


More information about the Patchwork mailing list