Explain the difference between optimistic and pessimistic locking, and when you would use each in a high-throughput data ingestion system.
