Re: database corruption question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: database corruption question
Дата
Msg-id 29767.1160611133@sss.pgh.pa.us
обсуждение исходный текст
Ответ на database corruption question  (maa1666@yahoo.fr)
Список pgsql-general
maa1666@yahoo.fr writes:
> In the document "Transaction Processing in PostgreSQL"
> ( http://www.postgresql.org/files/developer/transactions.pdf )

That's very, very old information.

> I read :
> "Postgres transactions are only guaranteed atomic if a disk page write
> is an atomic action.

Not true since the addition of full-page images to WAL.  These days the
only thing you really need to worry about is whether your disk drive
lies about write-complete.  A battery backed write cache is probably
safe enough.

            regards, tom lane

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

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: question on renaming a foreign key
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: question on renaming a foreign key