Re: Improvement of procArray.xmin for VACUUM - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Improvement of procArray.xmin for VACUUM
Date
Msg-id 1174937231.6069.428.camel@silverbirch.site
Whole thread Raw
In response to Re: Improvement of procArray.xmin for VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Fri, 2007-03-23 at 17:35 -0400, Tom Lane wrote:
> To make intra-transaction advancing of xmin possible, we'd need to
> explicitly track all of the backend's live snapshots, probably by
> introducing a "snapshot cache" manager that gives out tracked
> refcounts
> as we do for some other structures like catcache entries.  This might
> have some other advantages (I think most of the current CopySnapshot
> operations could be replaced by refcount increments)

Seems like we should do this for many reasons, whether or not this is
one of them. I seem to have butted heads and lost more than once with
not being able to tell which Snapshots exist.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-patches] [HACKERS] less privileged pl install
Next
From: "Simon Riggs"
Date:
Subject: Re: Improvement of procArray.xmin for VACUUM