| From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
|---|---|
| To: | "'Martin Devera'" <devik(at)cdi(dot)cz> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | RE: WAL & SHM principles |
| Date: | 2001-03-09 20:11:36 |
| Message-ID: | 8F4C99C66D04D4118F580090272A7A234D3306@sectorbase1.sectorbase.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > But needed if we want to get rid of vacuum and have savepoints.
>
> Hmm. How do you implement savepoints ? When there is rollback
> to savepoint do you use xlog to undo all changes which the particular
> transaction has done ? Hmmm it seems nice ... these resords are locked by
> such transaction so that it can safely undo them :-)
> Am I right ?
Yes, but there is no savepoints in 7.1 - hopefully in 7.2
> But how can you use xlog to get rid of vacuum ? Do you treat
> all delete log records as candidates for free space ?
Vaccum removes deleted records *and* records inserted by aborted
transactions - last ones will be removed by UNDO.
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-09 20:17:05 | Re: AW: AW: WAL does not recover gracefully from out-of -dis k-sp ace |
| Previous Message | Mikheev, Vadim | 2001-03-09 20:08:54 | RE: AW: AW: WAL does not recover gracefully from out-of -dis k-sp ace |