Hi Rob & Konstantin, > > > I'm still seeing this slowness and now to add to that intermittent > > 503 errors.
OK, I've heard the same yesterday from the ovn folks. Sounds like this is continuing after a recent hardware upgrade too. So far it does seem time of day related, so possibly conflicting with load from overnight backups. > In case it helps, and just for the record, the following index really > helped to improve some of the patch list views when delegates were > used: > > ALTER TABLE patchwork_patch ADD INDEX > patchwork_patch_delegate_id_state_id_archived (delegate_id, state_id, > archived); Neat, good to know! I'll check out the query log and see if we have overlap on the 'expensive' queries issued, and add the index if it looks like that would help. Cheers, Jeremy _______________________________________________ Patchwork mailing list Patchwork@lists.ozlabs.org https://lists.ozlabs.org/listinfo/patchwork