> > > 	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".

Vadim


Wed, 21 Jun 2000 17:20:38 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: Big 7.1 open items 
> -----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 

Thu, 22 Jun 2000 09:45:46 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
RE: Big 7.1 open items 