long transaction with concurrent SELECT statements

Поиск
Список
Период
Сортировка
Искать
От
Tim Baumgartner
Тема
long transaction with concurrent SELECT statements
Дата
Msg-id
43AAC50D.9060508@gmx.de
Список
Дерево обсуждения
long transaction with concurrent SELECT statements Tim Baumgartner <jongleur0815@gmx.de>
Re: long transaction with concurrent SELECT statements Tom Lane <tgl@sss.pgh.pa.us>
Hi,

I have a transaction that updates several tables und runs a few minutes. 
During this transaction, another connection makes SELECTs from tables 
that are being modified by the first connection. Althaugh the second 
connection doesn't modify any rows, it has to wait until the first 
transaction is commited.
I didn't specify a concurrency mode and the first transaction didn't 
explicitly lock any rows or tables for update.

Do you have an idea what might be wrong here?

Greetings
Tim
В списке pgsql-novice по дате отправления
От: Mag Gam
Дата:
От: Mag Gam
Дата:
FAQ