This is exactly how we arrived at our solution. We needed to satisfy the constraint; locking was one means of addressing the constraint. Maybe we were lucky in

This is exactly how we arrived at our solution. We needed to satisfy the constraint; locking was one means of addressing the constraint. Maybe we were lucky in our implementation, but a key factor for our decision was understanding how to manage the systems in our environment. We would have skilled up with Redis, but we felt our Postgres solution would be a good first step. We just haven't had a need to go to a second step yet.