Skip site navigation (1) Skip section navigation (2)

Re: Help tuning autovacuum - seeing lots of relationbloat

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Date: 2006-06-23 12:32:29
Message-ID: 449BDF5D.3060109@logix-tt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Markus SchaberDate: 2006-06-23 12:40:47
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Previous:From: Markus SchaberDate: 2006-06-23 12:02:27
Subject: Re: SAN performance mystery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group