On Fri, 2022-03-18 at 11:38 -0500, Merlin Moncure wrote: > > Also, you should nevr explicitly lock tables. Table locks are taken > > automatically > > by the SQL statements you are executing. > > Isn't that a bit of overstatement? > LOCK table foo; > > Locks the table, with the benefit you can choose the lockmode to > decide what is and is not allowed to run after you lock it. The main > advantage vs automatic locking is preemptively blocking things so as > to avoid deadlocks.
Yes, that was an overstatement. But I find that 90% of the time when people explicitly lock a table it is not the correct solution. Yours, Laurenz Albe
