On Fri, Sep 01, 2006 at 01:35:20PM -0400, Tom Lane wrote: > Matteo Sgalaberni <sgala@xxxxxxxxx> 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
