Re: Insert waiting for update?

<table cellspacing='0' cellpadding='0' border='0' ><tr><td style="font: inherit;"><br><br>--- On <b>Wed, 9/1/08, Ashish Karalkar <i>&lt;ashish_postgre(at)yahoo(dot)co(dot)in&gt;</i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Ashish Karalkar &lt;ashish_postgre(at)yahoo(dot)co(dot)in&gt;<br>Subject: [GENERAL] Insert waiting for update?<br>To: "pggeneral" &lt;pgsql-general(at)postgresql(dot)org&gt;<br>Cc: ashish(dot)karalkar(at)netcore(dot)co(dot)in<br>Date: Wednesday, 9 January, 2008, 4:29 PM<br><br><div id="yiv2031388839"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;">Dear list members,<br>I am having table with 4M rows.<br>I am trying to update all these rows with statement<br><br>update mytable set mycolumn=0;<br><br>At
the same time there are insert happening on the table.<br>but all these insert are in waiting mode. <br>does update is locking the table for insert?<br><br>does insert and update confilict with each other?<br>With regards<br>Ashihsh<br><br><br>For more details:<br><br>I have two tables master,child.<br>with child having fk to master.<br><br>Now that master table contains 4M rows . while I update them (Master table) the inserts are going into waiting mode on child table.<br><br><br>Update&nbsp; acquired row exclusive lock on master table&nbsp; , and the insert on child table acquired access share and share lock,row share on master. <br><br>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?<br><br><br><br>With Regards<br>Ashish...<br><br><br><br><br><br><br><br><br></td></tr></tbody></table><br>

<hr size="1"> Save all your chat conversations. <a rel="nofollow" target="_blank" href="http://in.rd.yahoo.com/tagline_webmessenger_3/*http://in.messenger.yahoo.com/webmessengerpromo.php">Find them online.</a>
</div></blockquote></td></tr></table><br>

<!--1--><hr size=1></hr> Why delete messages? Unlimited storage is <a href="http://in.rd.yahoo.com/tagline_mail_1/*http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/">just a click away.</a>