On Thu, Jan 7, 2021 at 11:50 AM Craig Jackson <craig(dot)jackson(at)broadcom(dot)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