From: Markus Schaber <schabi@logix-tt.com>
To: pgsql-performance@postgresql.org
Subject: Re: database bloat,non removovable rows, slow query etc...
Date: Mon, 04 Sep 2006 09:35:13 +0200
Message-ID: <44FBD731.10105@logix-tt.com> (raw)
In-Reply-To: <20060902083725.GB2266@sgala.com>
References: <20060901123915.GT2266@sgala.com>
<4027.1157121810@sss.pgh.pa.us>
<20060901172829.GX2266@sgala.com>
<12756.1157132120@sss.pgh.pa.us>
<20060902083725.GB2266@sgala.com>
Hi, Matteo,
Matteo Sgalaberni wrote:
> A my collegue JDBC application that stay in "idle intransaction" 24h/24h
Just a little note: For most applications, this can be fixed updating
the JDBC driver. Old versions had the behaviour of auto-opening a new
backend transaction on commit/rollback, whereas new versions delay that
until the first statement in the new transaction is sent.
This won't fix applications that do a select and then sit idle for days
before committing/rolling back, however. Those should be fixed or use
autocommit mode.
> Good to know this...but why this behaviour? it'is lovely...:)
>
> Tom , can you explain why?...
It is because the transaction IDs are global per cluster.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabi@logix-tt.com
Subject: Re: database bloat,non removovable rows, slow query etc...
In-Reply-To: <44FBD731.10105@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox