Re: database corruption question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maa1666(at)yahoo(dot)fr
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database corruption question
Date: 2006-10-11 23:58:53
Message-ID: 29767.1160611133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

maa1666(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2006-10-12 00:04:34 Re: question on renaming a foreign key
Previous Message Richard Broersma Jr 2006-10-11 23:53:48 Re: question on renaming a foreign key