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

From: Gregory Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Matteo Sgalaberni <sgala(at)sgala(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: database bloat, non removovable rows, slow query etc... [RESOLVED]
Date: 2006-09-04 22:13:34
Message-ID: 87ejur1drl.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Matteo Sgalaberni <sgala(at)sgala(dot)com> 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 overhead
> that'd be added to *every* GetSnapshotData call is a bit worrisome.

Don't we do that now in CVS (ie, in 8.2)?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-04 22:47:16 Re: database bloat, non removovable rows, slow query etc... [RESOLVED]
Previous Message Roman Krylov 2006-09-04 20:42:28 64bit vs 32bit build on amd64