Re: long transaction with concurrent SELECT statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: long transaction with concurrent SELECT statements
Дата
Msg-id 23884.1135272355@sss.pgh.pa.us
обсуждение исходный текст
Ответ на long transaction with concurrent SELECT statements  (Tim Baumgartner <jongleur0815@gmx.de>)
Список pgsql-novice
Tim Baumgartner <jongleur0815@gmx.de> writes:
> 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.

You're probably going to have to show us exactly what you're doing,
because that shouldn't be happening as stated; ergo you've left out
some critical detail.

            regards, tom lane

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

Предыдущее
От: Mag Gam
Дата:
Сообщение: Re: Tsearch 2, index in different table?
Следующее
От:
Дата:
Сообщение: Re: Tsearch 2, index in different table?