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