Slow Post due to massive out of sync on a certain table or due to a DML on a certain table (such (4300021)

Sometimes transactions executed on a particular table can cause Post to slow down considerably.

Two common examples are an out of sync on a table or a large DELETE transaction on a table that has no key.

In case of out of sync, slowness can be caused due to no key existing on the target table, too much or logging activity on errlog.sql and event log as well as caching of rowids.

In case of DELETEs, slowness can be due to the # of rows involved in the transaction or due to no key existing on the target table.