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