Related to this, there is quite a large variation across Postgres versions about... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

glenjamin on April 29, 2024 | parent | context | favorite | on: Common DB schema change mistakes in Postgres

Related to this, there is quite a large variation across Postgres versions about whether a particular DML query will take an exclusive lock or not.

Is there a good way to analyse a query and be informed of what sort of lock it will take?

I’ve always resorted to re-reading docs when I’m unsure.

kroolik on April 29, 2024 [–]

For me the best way is testing it locally, side-by-side, with two transactions. You dont need any data for this.

After some experience, you start to see the reasons for locks and how they will impact you.

Or read the docs.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact