RE: CRCs
От | Mikheev, Vadim |
---|---|
Тема | RE: CRCs |
Дата | |
Msg-id | 8F4C99C66D04D4118F580090272A7A234D3271@sectorbase1.sectorbase.com обсуждение исходный текст |
Ответ на | CRCs (ncm@zembu.com (Nathan Myers)) |
Ответы |
Re: CRCs
|
Список | pgsql-hackers |
> > But physical log recovery will rewrite every page that was changed > > after last checkpoint, thus this is not an issue anymore. > > No. That assumes that when the drive _says_ the block is written, > it is really on the disk. That is not true for IDE drives. It is > true for SCSI drives only when the SCSI spec is implemented correctly, > but implementing the spec correctly interferes with favorable > benchmark results. You know - this is *core* assumption. If drive lies about this then *nothing* will help you. Do you remember core rule of WAL? "Changes must be logged *before* changed data pages written". If this rule will be broken then data files will be inconsistent after crash recovery and you will not notice this, w/wo CRC in data blocks. I agreed that CRCs could help to detect other errors but probably it's too late for 7.1 Vadim
В списке pgsql-hackers по дате отправления: