Insert waiting for update?

Поиск
Список
Период
Сортировка
От Ashish Karalkar
Тема Insert waiting for update?
Дата
Msg-id 113240.39813.qm@web94606.mail.in2.yahoo.com
обсуждение исходный текст
Ответы Re: Insert waiting for update?  (Ashish Karalkar <ashish_postgre@yahoo.co.in>)
Re: Insert waiting for update?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
<td style=3D"f=
ont: inherit;">Dear list members,I am having table with 4M rows.I a=
m trying to update all these rows with statementupdate mytable set =
mycolumn=3D0;At the same time there are insert happening on the tab=
le.but all these insert are in waiting mode. does update is locking=
 the table for insert?does insert and update confilict with each ot=
her?With regardsAshihs


       Save all your chat conversations. <a href=
=3D"http://in.rd.yahoo.com/tagline_webmessenger_3/*http://in.messenger.yaho=
o.com/webmessengerpromo.php">Find them online.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: count(*) and bad design was: Experiences with extensibility
Следующее
От: "Willy-Bas Loos"
Дата:
Сообщение: performance differences of major versions