On Thu, Jan 7, 2021 at 11:50 AM Craig Jackson <craig.jack...@broadcom.com>
wrote:

> We had a similar situation recently and saw high commit times that were
> caused by having unindexed foreign key columns when deleting data with
> large tables involved.  You might check to see if any new foreign key
> constraints have been added recently or if any foreign key indexes may have
> inadvertently been removed. Indexing the foreign keys resolved our issue.
>

Interesting, I'll run a check for any. Thanks!

Don.

-- 
Don Seiler
www.seiler.us

Reply via email to