Re: PostgreSQL and Journaled File Systems - Mailing list pgsql-sql

From Tom Lane
Subject Re: PostgreSQL and Journaled File Systems
Date
Msg-id 9182.1060206619@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL and Journaled File Systems  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Andrew Droffner
Date:
Subject: Re: User-defined SQL function has slower query on 7.3.3 than
Next
From: "Maksim Likharev"
Date:
Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram