PostgreSQL Application Advisorial Lock

The application advisory lock has probably its own topic to be honest. But advisory lock are those locks that are acquired by the application. So let's take a look here. This acquires a row level lock on the row with a specified account number. And the second transaction executes this update, sits account two. Right. Transaction two already hold the lock. Thus transaction one is blocked on transaction two. Postgres will detect this and abort the transaction immediately. It's called a deadlock graph. Very careful, especially when when you're up when two transaction try to update the same rows in certain order.

Transcript

Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.