Skip site navigation (1) Skip section navigation (2)

Re: WIP patch for system-catalog vacuuming via a relation map

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP patch for system-catalog vacuuming via a relation map
Date: 2010-02-06 00:24:57
Message-ID: 4B6CB6D9.9040901@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>>> Barring objections I'm going to press ahead with completing and
>>> committing this; then in a separate patch remove VACUUM FULL INPLACE.
> 
>> Was it our determination that we could remove VFI if we eliminated the
>> system catalogs?  I'm fine with it, I just thought some people had a
>> marginal use case for VFI.
> 
> I thought the consensus was to remove it if possible.  There may still
> be some "marginal" use cases, but they don't justify the work that'd
> be needed to make it play safely with HS; let alone fixing the other
> longstanding gotchas with it, like the double-commit risk.

I think part of the plan was to also provide an online reorg tool that
works by doing dummy UPDATEs, which means that you can get serialization
errors in serializable mode, but doesn't need to lock the table.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-hackers by date

Next:From: Andres FreundDate: 2010-02-06 00:39:53
Subject: Re: Confusion over Python drivers
Previous:From: Bruce MomjianDate: 2010-02-05 23:55:39
Subject: Re: Hot standby documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group