Ashish Karalkar wrote: > I am having table with 4M rows. > I am trying to update all these rows with statement > > update mytable set mycolumn=0; > > At the same time there are insert happening on the table. > but all these insert are in waiting mode. > does update is locking the table for insert? > > does insert and update confilict with each other? > > For more details: > > I have two tables master,child. > with child having fk to master. > > Now that master table contains 4M rows . while I update them > (Master table) the inserts are going into waiting mode on child table. > > > Update acquired row exclusive lock on master table , and > the insert on child table acquired access share and share > lock,row share on master. > > Is this is what preventing for inserting records into child > table, I mean is the row exclusive lock conflicting with the > locks insert wants to hold?
Please post the table definitions including indexes and constraints. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings