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: (view raw or whole 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
The Enterprise PostgreSQL Company

In response to


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-2015 The PostgreSQL Global Development Group