Re: database corruption question - Mailing list pgsql-general

From Tom Lane
Subject Re: database corruption question
Date
Msg-id 29767.1160611133@sss.pgh.pa.us
Whole thread Raw
In response to database corruption question  (maa1666@yahoo.fr)
List 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 by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: question on renaming a foreign key
Next
From: Ron Johnson
Date:
Subject: Re: question on renaming a foreign key