AW: AW: AW: AW: AW: WAL-based allocation of XIDs is ins ecur e - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: AW: AW: AW: WAL-based allocation of XIDs is ins ecur e
Date
Msg-id 11C1E6749A55D411A9670001FA68796336822D@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > Before commit or rollback the xlog is not flushed to disk, thus you can loose
> > those xlog entries, but the index page might already be on disk because of
> > LRU buffer reuse, no ?
> 
> No. Buffer page is written to disk *only after corresponding records are flushed
> to log* (WAL means Write-Ahead-Log - write log before modifying data pages).

You mean, that for each dirty buffer that is reused, the reusing backend fsyncs
the xlog before writing the buffer to disk ?

Andreas


pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: AW: AW: AW: AW: WAL-based allocation of XIDs is insecur e
Next
From: "Vadim Mikheev"
Date:
Subject: Re: How to shoot yourself in the foot: kill -9 postmaster