long transaction with concurrent SELECT statements - Mailing list pgsql-novice

From Tim Baumgartner
Subject long transaction with concurrent SELECT statements
Date
Msg-id 43AAC50D.9060508@gmx.de
Whole thread Raw
Responses Re: long transaction with concurrent SELECT statements
List pgsql-novice
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 by date:

Previous
From: Mag Gam
Date:
Subject: Tsearch 2, index in different table?
Next
From: Mag Gam
Date:
Subject: Re: Tsearch 2, index in different table?