From: Matteo Sgalaberni <sgala@sgala.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: database bloat, non removovable rows, slow query etc... [RESOLVED]
Date: Sat, 2 Sep 2006 10:37:25 +0200
Message-ID: <20060902083725.GB2266@sgala.com> (raw)
In-Reply-To: <12756.1157132120@sss.pgh.pa.us>
References: <20060901123915.GT2266@sgala.com>
<4027.1157121810@sss.pgh.pa.us>
<20060901172829.GX2266@sgala.com>
<12756.1157132120@sss.pgh.pa.us>
On Fri, Sep 01, 2006 at 01:35:20PM -0400, Tom Lane wrote:
> Matteo Sgalaberni <sgala@sgala.com> writes:
> > Ok. I stopped all clients. No connections to this database.
>
> When you say "this database", do you mean the whole postmaster cluster,
> or just the one database? Open transactions in other databases of the
> same cluster can be a problem.
>
AGH!!!! AGHR!!!
A my collegue JDBC application that stay in "idle intransaction" 24h/24h
(but in another database, non in the bloated-reported db...)!
I killed it now(jdbc app).
vacuumed full and PG have cleaned all!! So if I have a idle transaction in
one database of the cluster it "lock" vacuums of all databases of the cluster.
Good to know this...but why this behaviour? it'is lovely...:)
Tom , can you explain why?...
Thanks a lot!!
Matteo
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: sgala@sgala.com, tgl@sss.pgh.pa.us
Subject: Re: database bloat, non removovable rows, slow query etc... [RESOLVED]
In-Reply-To: <20060902083725.GB2266@sgala.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