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

From Tom Lane
Subject Re: long transaction with concurrent SELECT statements
Date
Msg-id 23884.1135272355@sss.pgh.pa.us
Whole thread Raw
In response to long transaction with concurrent SELECT statements  (Tim Baumgartner <jongleur0815@gmx.de>)
List 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 by date:

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