From: | Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> |
---|---|
To: | ashish_postgre(at)yahoo(dot)co(dot)in |
Cc: | pggeneral <pgsql-general(at)postgresql(dot)org>, ashish(dot)karalkar(at)netcore(dot)co(dot)in |
Subject: | Re: Insert waiting for update? |
Date: | 2008-01-09 13:29:48 |
Message-ID: | 83258.94346.qm@web94609.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<table cellspacing='0' cellpadding='0' border='0' ><tr><td style="font: inherit;"><br><br>--- On <b>Wed, 9/1/08, Ashish Karalkar <i><ashish_postgre(at)yahoo(dot)co(dot)in></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in><br>Subject: [GENERAL] Insert waiting for update?<br>To: "pggeneral" <pgsql-general(at)postgresql(dot)org><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 acquired row exclusive lock on master table , 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>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 2.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Harrison | 2008-01-09 14:02:23 | quick question abt pg_dump and restore |
Previous Message | Glyn Astill | 2008-01-09 13:28:00 | Re: Startup scripts - Use -m fast or smart? |