Postgres Table lock on delete query

Question

I have two aws task where one could be writing to table another could run delete query at the same time both could be running parallel queries but playing with different rows. so the question is if I run delete from table where column_name=some condition ? then will postgres apply table level lock or row level lock. If table level lock gets applied then another task will not able to write into table.

Laurenz Albe · Accepted Answer · 2020-08-10 09:19:10Z

4

PostgreSQL will only lock the rows you delete.

Concurrent INSERTs will not be affected.

answered Aug 10, 2020 at 9:19

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jjanes · Accepted Answer · 2020-08-10 13:38:55Z

2

There are many different lock modes. The table will be locked, but in a mode that still allows other INSERT, DELETE, and UPDATE operations to happen concurrently. The rows actually deleted will also be locked, in a more restrictive mode.

answered Aug 10, 2020 at 13:38

jjanes

45k5 gold badges39 silver badges48 bronze badges

1 Comment

Ankur Agarwal Over a year ago

Any documentation for this i.e. Rows being deleted are locked ?

Collectives™ on Stack Overflow

Postgres Table lock on delete query

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related