Re: High COMMIT times

2021-01-07 Thread Don Seiler
On Thu, Jan 7, 2021 at 11:50 AM Craig Jackson 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 a

Re: High COMMIT times

2021-01-07 Thread Craig Jackson
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 inadverten