SELECT … FOR UPDATE on non-existent rows

(Art van Scheppingen) SELECT … FOR UPDATE has a (not so) surprising side effect on non-existent rows: it could cause a (serious) performance penalty and even prevent you from inserting new rows at all.

Register to Read