We needed locks so queue workers did not process the same job twice.
Redis SET NX was faster under load and easy to expire automatically.
Postgres advisory locks were simpler operationally for our small team.
Failover behavior mattered more than raw latency in our case.
We chose Postgres first, then moved hot paths to Redis later.
Pick the lock store you can operate confidently at 3am.
Totals · 1 entries · 0 followers
Newest first
by Ananya Gupta
We needed locks so queue workers did not process the same job twice.
Redis SET NX was faster under load and easy to expire automatically.
Postgres advisory locks were simpler operationally for our small team.
Failover behavior mattered more than raw latency in our case.
We chose Postgres first, then moved hot paths to Redis later.
Pick the lock store you can operate confidently at 3am.
Separate opinion from lived experience. Mark what you have actually done.
Sign in to verify experiences. Authors cannot verify their own experiences.