Level 6 - ExpertOptimization Questionsm3 consistency integrity
Optimization: Conflict Handling Path
Choose the safer high-throughput insert strategy for idempotency table. Query A: INSERT INTO job_requests (idempotency_key, status) VALUES (:k, 'PENDING'); Query B: INSERT INTO job_requests (idempotency_key, status) VALUES (:k, 'PENDING') ON CONFLICT (idempotency_key) DO NOTHING;