Queues in Postgres
Postgres FM
00:00
The Importance of Skip Lock in Batching
When we have a single worker, latency and throughput are very well connected. If one is updating until the very end of transaction, commit or rollback, exclusive lock will be on this row,. And another worker will be just waiting on it. It can be seen in wait events analysis very well. In this case, we can use for update no wait or for updates skip lock. But remember, if you, for example, use John go or something and like sometimes like, subtransactions might pop up, keep locked.
Transcript
Play full episode
