AW: AW: AW: AW: AW: WAL-based allocation of XIDs is ins ecur e

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: AW: AW: AW: AW: WAL-based allocation of XIDs is ins ecur e
Дата
Msg-id 11C1E6749A55D411A9670001FA68796336822D@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Vadim Mikheev"
Дата:
Сообщение: Re: AW: AW: AW: AW: WAL-based allocation of XIDs is insecur e
Следующее
От: "Vadim Mikheev"
Дата:
Сообщение: Re: How to shoot yourself in the foot: kill -9 postmaster