Re: database bloat,non removovable rows, slow query etc... [RESOLVED]

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