From: Markus Schaber <schabi@logix-tt.com>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Date: Fri, 23 Jun 2006 14:32:29 +0200
Message-ID: <449BDF5D.3060109@logix-tt.com> (raw)
In-Reply-To: <1150904541.3309.38.camel@coppola.muc.ecircle.de>
References: <200606211052.43227.jody.brownell@q1labs.com>
<1150898912.3309.23.camel@coppola.muc.ecircle.de>
<200606211227.06618.jody.brownell@q1labs.com>
<1150904541.3309.38.camel@coppola.muc.ecircle.de>
Hi, Csaba,
Csaba Nagy wrote:
> Well, your application might be completely well behaved and still your
> DBA (or your favorite DB access tool for that matter) can leave open
> transactions in an interactive session. It never hurts to check if you
> actually have "idle in transaction" sessions. It happened a few times to
> us, some of those were bad coding on ad-hoc tools written by us, others
> were badly behaved DB access tools opening a transaction immediately
> after connect and after each successful command, effectively leaving an
> open transaction when leaving it open while having lunch...
Some older JDBC driver versions had the bug that they always had an open
transaction, thus an application server having some pooled connections
lingering around could block vacuum forever.
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: Help tuning autovacuum - seeing lots of relationbloat
In-Reply-To: <449BDF5D.3060109@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