Re: XFS for postgres databases?

[Andi Kleen <ak@xxxxxx>]

Feizhou <feizhou@xxxxxxxxxxxxx> writes:
>
> Why would you put a database on a meta data journaling only filesystem?

Databases do their own journaling. Doing another journaling
layer for the data in the file system is just a waste of IO bandwidth.

In addition the data journaling in the file system is quite useless
for this because the fs doesn't have any idea about the transaction
boundaries the database needs. The database tells the file system
about them using fsync() or synchronous writes, and there is not much
difference between a data journaling and not data journaling fs for this -
both will flush the blocks to disk.

-Andi