| 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:16:30 |
| Message-ID: | 000301bfdbdf$1d0dd920$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]
>
> > If we bit the bullet and restricted ourselves to numeric filenames then
> > the log would need just four numeric values:
> > database OID
> > tablespace OID
>
> Is someone going to implement it for 7.1?
>
> > relation OID
> > 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
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikheev, Vadim | 2000-06-22 00:20:38 | RE: Big 7.1 open items |
| Previous Message | Hiroshi Inoue | 2000-06-21 23:37:42 | RE: Big 7.1 open items |