RE: Big 7.1 open items - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Big 7.1 open items
Date
Msg-id 000401bfdbe3$3420fee0$2801007e@tpf.co.jp
Whole thread Raw
In response to RE: Big 7.1 open items  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
> -----Original Message-----
> From: Mikheev, Vadim [mailto:vmikheev@SECTORBASE.COM]
> 
> > > >     relation version number
> > > 
> > > I believe that we can avoid versions using WAL...
> > >
> > 
> > How to re-construct tables in place ?
> > Is the following right ?
> > 1) save the content of current table to somewhere
> > 2) shrink the table and related indexes
> > 3) reload the saved(+some filtering) content
> 
> Or - create tmp file and load with new content; log "intent to 
> relink table
> file";
> relink table file; log "file is relinked".
>

It seems to me that whole content of the table should be
logged before relinking or shrinking.
Is my understanding right ?

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp 


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Big 7.1 open items
Next
From: Chris Bitmead
Date:
Subject: Re: Big 7.1 open items