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

Re: extending relations more efficiently

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Jeroen Vermeulen <jtv(at)xs4all(dot)nl>, Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: extending relations more efficiently
Date: 2012-05-02 16:55:17
Message-ID: CA+Tgmob0-KsEiiAJy19bHhecWoEbjq6NUfvt9ESDX4rjskzJUw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, May 2, 2012 at 12:46 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Agreed.  Perhaps to solve this issue what we need is a way to migrate
> tuples from later pages into earlier ones.  (This was one of the points,
> never resolved, that we discussed during the VACUUM FULL rework.)

Yeah, I agree.  And frankly, we need to find a way to make it work
without taking AccessExclusiveLock on the relation.  Having to run
VACUUM FULL is killing actual users and scaring off potential ones.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-05-02 16:55:38
Subject: Re: clog double-dip in heap_hot_search_buffer
Previous:From: Alvaro HerreraDate: 2012-05-02 16:46:37
Subject: Re: extending relations more efficiently

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