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
Dear list members,I am having table with 4M rows.I am trying to update all these rows with statementupdate 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 con
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
Hi,
after some more debugging I found that my application does on average 3
inserts per second. Which is not very fast, but fast enough for now. But
now and then the whole insert proces will be stalled and drop to 0.1
inserts per second. In the output of "ps aux Op" I see postgres in the
state
