Re: New VACUUM FULL still needed? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: New VACUUM FULL still needed?
Date
Msg-id 1260843982.1955.3436.camel@ebony
Whole thread Raw
In response to New VACUUM FULL still needed?  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
On Tue, 2009-12-15 at 11:17 +0900, Takahiro Itagaki wrote:
> Simon Riggs <simon@2ndQuadrant.com> wrote:
> 
> > I have enough items emerging from HS to keep me busy much longer than I
> > thought. I'll run with VF if that's OK, since I have some other related
> > changes in that area and it makes sense to understand that code also, if
> > OK with you.
> 
> Sure. Many users want to see HS.
> 
> BTW, New VACUUM FULL patch is waiting for being applied.
>     https://commitfest.postgresql.org/action/patch_view?id=202
> But I heard HS is attempting to modify VFI in another way or remove it
> completely. Do we still need the patch, or reject it and fix VFI in HS?

Plan is to apply patch for new VF, then for me to write another patch to
allow new VF to work with system relations also. 

VACUUM FULL INPLACE would then be prohibited if recovery_connections =
on, which given that is the default will pretty much reduce VFI to not
working at all in 8.5. But it remains an option if problems occur.

My intention is to keep all of the code there for 8.5 and then begin
removing old VF code at beginning of 8.6dev. It's been there too long
and is in far too deep to rip it out quickly. There's no mileage in
spending time on removing a non-feature when there is feature work to be
done.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Takahiro Itagaki
Date:
Subject: New VACUUM FULL still needed?
Next
From: Jaime Casanova
Date:
Subject: Re: Syntax for partitioning