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 inser
?With RegardsAshish...--- On Wed, 9/1/08, Albe Laurenz <[EMAIL PROTECTED]> wrote:From: Albe Laurenz <[EMAIL PROTECTED]>Subject: Re: [GENERAL] Insert waiting for update?To: [EMAIL PROTECTED], "pggeneral" Cc: [EMAIL PROTECTED]Date: Wednesday, 9 January, 2008, 8:53 PMAshish Karalk
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 inser
--- On Wed, 9/1/08, Ashish Karalkar <[EMAIL PROTECTED]> wrote:From: Ashish Karalkar <[EMAIL PROTECTED]>Subject: [GENERAL] Insert waiting for update?To: "pggeneral" Cc: [EMAIL PROTECTED]Date: Wednesday, 9 January, 2008, 4:29 PMDear list members,I am having table with 4M rows.I am trying to update al
Hi John,
but how long is the exclusive lock taken? For the whole transaction?
My jobs are quite big, and transactions usually take several minutes.
I can not afford have all my other jobs stalled for that time.
Ulrich
I believe foreign key constraints take an exclusive lock on the parent.
If you a
I believe foreign key constraints take an exclusive lock on the parent.
If you are inserting two child records that reference the same parent
(at the same time) one insert will block.
John Sidney-Woollett
Ulrich Wisser wrote:
Hi,
after some more debugging I found that my application does on aver
