Re: [HACKERS] Undetected corruption of table files

Поиск
Список
Период
Сортировка
От Trevor Talbot
Тема Re: [HACKERS] Undetected corruption of table files
Дата
Msg-id 90bce5730708270848p3d8ae18y56325c5a269c0566@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Undetected corruption of table files  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: [HACKERS] Undetected corruption of table files
Список pgsql-general
On 8/27/07, Jonah H. Harris <jonah.harris@gmail.com> wrote:
> On 8/27/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > that and the lack of evidence that they'd actually gain anything
>
> I find it somewhat ironic that PostgreSQL strives to be fairly
> non-corruptable, yet has no way to detect a corrupted page.  The only
> reason for not having CRCs is because it will slow down performance...
> which is exactly opposite of conventional PostgreSQL wisdom (no
> performance trade-off for durability).

But how does detecting a corrupted data page gain you any durability?
All it means is that the platform underneath screwed up, and you've
already *lost* durability.  What do you do then?

It seems like the same idea as an application trying to detect RAM errors.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ANNOUNCE] == PostgreSQL Weekly News - August 26 2007 ==
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Undetected corruption of table files