I perform SELECT FOR UPDATE in my app.
What happens if row will not be updated and no writes for this row will perform, how long this lock will exists?
And is it possible to monitor such rows (rows selected for update)?
Asked
Active
Viewed 973 times
2
Sonique
- 6,670
- 6
- 41
- 60
-
1https://stackoverflow.com/questions/1063043/how-to-release-possible-postgres-row-locks/23060492 – lexicore Oct 09 '17 at 08:11
-
2In normal cases, until the end of the transaction. – Kayaman Oct 09 '17 at 08:34
-
What do you mean by monitor? – JustMe Oct 09 '17 at 13:23
-
For example count and duration of locks. lexicore anwswer this questions above. – Sonique Oct 09 '17 at 13:46
-
Yes - but we're talking about locks, not rows acquired by lock as you write in the question. – JustMe Oct 09 '17 at 13:51
-
Sorry, I'm not DBA and maybe write something wrong, but `SELECT FOR UPDATE` locks rows, that's what about my question. You can suggest improvement. – Sonique Oct 09 '17 at 13:54