Thread: long transaction with concurrent SELECT statements

long transaction with concurrent SELECT statements

From
Tim Baumgartner
Date:
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

Re: long transaction with concurrent SELECT statements

From
Tom Lane
Date:
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