Re: PostgreSQL and Journaled File Systems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PostgreSQL and Journaled File Systems
Date: 2003-08-06 21:50:19
Message-ID: 9182.1060206619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Roberto Mello <rmello(at)cc(dot)usu(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Maksim Likharev 2003-08-06 22:04:38 Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Previous Message Sam Barnett-Cormack 2003-08-06 21:39:52 Re: PostgreSql under Linux