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

2006-09-02 Thread Matteo Sgalaberni
On Fri, Sep 01, 2006 at 01:35:20PM -0400, Tom Lane wrote: Matteo Sgalaberni [EMAIL PROTECTED] 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

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

2006-09-02 Thread Dave Cramer
Matteo, On 2-Sep-06, at 4:37 AM, Matteo Sgalaberni wrote: On Fri, Sep 01, 2006 at 01:35:20PM -0400, Tom Lane wrote: Matteo Sgalaberni [EMAIL PROTECTED] writes: Ok. I stopped all clients. No connections to this database. When you say this database, do you mean the whole postmaster

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

2006-09-02 Thread Tom Lane
Matteo Sgalaberni [EMAIL PROTECTED] writes: Good to know this...but why this behaviour? it'is lovely...:) Open transactions are tracked across the whole cluster. This is necessary when vacuuming shared catalogs. In principle we could track per-database xmin values as well, but the distributed