Re: Migrating from Informix to Postgre - Mailing list pgsql-general

From Tommi Maekitalo
Subject Re: Migrating from Informix to Postgre
Date
Msg-id 200210211503.00099.t.maekitalo@epgmbh.de
Whole thread Raw
In response to Re: Migrating from Informix to Postgre  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Migrating from Informix to Postgre
List pgsql-general
>
> > 4. Does it support raw devices?
>
> No.  We feel the performance improvement on raw devices is minimal.
>
But what about data-integrity? I've learned, that a write on a raw device
guarantees, that the data is physically on the harddisk, when it returns.
When you write into the filesystem you don't even have control about the
order, in which writes are physically executed.

It would be difficult to guarantee dataintegrity, when the datapages are
written before WAL is on the hard-disk. That's why the Informix-people
strongly suggests to use raw-devices.

What does Postgresql do to guaratee it?


Tommi

--
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de

pgsql-general by date:

Previous
From: Andrei Ivanov
Date:
Subject: Re: creating a new type in C
Next
From: "Peter Kovacs"
Date:
Subject: Re: [JDBC] Prepared statement performance...