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 01:30:23 |
Message-ID: | 8F4C99C66D04D4118F580090272A7A23018C2F@SECTORBASE1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > > > 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.
> >
> > Why not just fsync tmp files?
> >
>
> Probably I've misunderstood *relink*.
> If *relink* different from *rename* ?
I ment something like this - link(table file, tmp2 file); fsync(tmp2 file);
unlink(table file); link(tmp file, table file); fsync(table file);
unlink(tmp file). We can do additional logging (with log flush) of these
steps
if required, postpone on-recovery redo of operations till last relink log
record/
end of log/transaction abort etc etc etc.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Randall Parker | 2000-06-22 01:45:20 | Re: An idea on faster CHAR field indexing |
Previous Message | Hiroshi Inoue | 2000-06-22 01:27:26 | RE: Big 7.1 open items |