| From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
| Cc: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Thomas Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
| Subject: | RE: Big 7.1 open items |
| Date: | 2000-06-22 00:45:46 |
| Message-ID: | 000401bfdbe3$3420fee0$2801007e@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: Mikheev, Vadim [mailto:vmikheev(at)SECTORBASE(dot)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(at)tpf(dot)co(dot)jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikheev, Vadim | 2000-06-22 01:11:03 | RE: Big 7.1 open items |
| Previous Message | Chris Bitmead | 2000-06-22 00:43:20 | Re: Big 7.1 open items |