| From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
|---|---|
| To: | "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp> |
| 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:20:38 |
| Message-ID: | 8F4C99C66D04D4118F580090272A7A23018C2C@SECTORBASE1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Bitmead | 2000-06-22 00:43:20 | Re: Big 7.1 open items |
| Previous Message | Hiroshi Inoue | 2000-06-22 00:16:30 | RE: Big 7.1 open items |