Select FOR UPDATE considered harmful in PostgreSQL(cybertec-postgresql.com)

44 pointsby samokhvalovw zeszłym roku2 comments

Select FOR UPDATE considered harmful in PostgreSQL

https://www.cybertec-postgresql.com/en/select-for-update-considered-harmful-postgresql/

2 comments

gmcabritaw zeszłym roku

> PostgreSQL takes FOR UPDATE on rows before a DELETE, or before an UPDATE that modifies a column that is part of a unique index that neither contains expressions nor is partial

This also happens when you UPDATE the same row twice within the same transaction.

https://goncalo.mendescabrita.com/blog/cross-table-lock/

rickettew zeszłym roku

tl;dr "Unless you plan to delete a row or modify a key column, always use SELECT FOR NO KEY UPDATE".