Thread: PostgreSQL and Journaled File Systems

Hi All,

What is the word about using PG with journaled file systems? I have heard
that it's best to not have the PG journal in a journaled system to avoid
double journaling.

Can someone that understand the issues involved (performance, reliability)
please shed some light on the issue?

Thanks in advance,

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
If I only had a nickel for every time Windows crashed ...

Roberto Mello <rmello@cc.usu.edu> writes:
> What is the word about using PG with journaled file systems? I have heard
> that it's best to not have the PG journal in a journaled system to avoid
> double journaling.

Journaling metadata is good.  Journaling file contents is redundant ---
turn that off if you can.  (Of course, if there is anything other than
Postgres files on the same device, you may not want to turn off contents
journalling...)
        regards, tom lane