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 по дате отправления