Long running transactions

From: Wayne Schroeder <raz(at)positivenetworks(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Long running transactions
Date: 2006-03-21 00:25:23
Message-ID: 441F47F3.1030207@positivenetworks.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a quite heavily accessed database that is vacuumed nightly.
Attached to that database are processes, that at times, due to the way
they are coded, stay "idle in transaction" for long periods of time
(client lib implementation issues a BEGIN). I've been reading up on
XIDs and the like and I'm trying to determine if this is going to cause
problems.

The reason I ask is one of these processes blocked a slony replication
set from doing it's initial copy with a warning about an old transaction
id. It made me wonder if long running transactions could some how hurt
things in other areas. Obviously the slony copy is not an issue for the
postgres list -- I am more interested in the effects of long running
transactions in general.

Wayne

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-21 00:45:27 Re: Long running transactions
Previous Message Murali K. Maddali 2006-03-21 00:22:32 xml output