Re: Migrating from Informix to Postgre

Tommi Maekitalo <t(dot)maekitalo(at)epgmbh(dot)de> writes:

> >
> > > 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?

We call fsync() on the WAL files, which guarantees data is written
when it returns.

-Doug