ThrawnCA
commented
8 months ago - Use TRUNCATE with a short locking timeout, instead of dropping and recreating a table, when data structure has not changed
- Retry jobs that fail due to locking problems
- Acquire write locks up front when updating resource metadata so race conditions don't cause deadlock