Skip to content
Advertisement

Redshift: Support for concurrent inserts in the same table

I have a lambda code that fires some insert queries to the same Table concurrently through redshift data api.

Considering such queries will be fired concurrently, does Redshift apply a lock to the Table for each insert? Or does it allow parallel insert queries in the same table? I’m asking because postgres allows concurrent inserts.

https://www.postgresql.org/files/developer/concurrency.pdf

Advertisement

Answer

Based on the discussion in comments, one can conclude that concurrent inserts into the same table in Redshift are blocking in nature as opposed to postgres. Refer to the docs:- https://docs.aws.amazon.com/redshift/latest/dg/r_Serializable_isolation_example.html

Edit:-

FYI if you are thinking what is the exact information to look for in the above mentioned docs, I am directly pasting it below:-

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement