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

2006-09-04 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > I must be misunderstanding Tom's comment then. > What I'm referring to is lazy_vacuum_rel() calls vacuum_set_xid_limits with > the relisshared flag of the relation. vacuum_set_xid_limits passes that to > GetOldestXmin as the allDbs parameter. GetOldestX

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

2006-09-04 Thread Gregory Stark
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Gregory Stark wrote: > > Tom Lane <[EMAIL PROTECTED]> writes: > > > > > Matteo Sgalaberni <[EMAIL PROTECTED]> writes: > > > > Good to know this...but why this behaviour? it'is lovely...:) > > > > > > Open transactions are tracked across the whole clu

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

2006-09-04 Thread Alvaro Herrera
Gregory Stark wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > > 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

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

2006-09-04 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > 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 pe

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 distribute

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 clus

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 ot