Re: Would it be OK if I put db file on a ext2 filesystem?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Magicloud Wang" <magicloud(dot)magiclouds(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Would it be OK if I put db file on a ext2 filesystem?
Date: 2007-12-12 04:24:21
Message-ID: dcc563d10712112024t226cb7clcfe51edf6bcf9971@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 11, 2007 9:55 PM, Magicloud Wang <magicloud(dot)magiclouds(at)gmail(dot)com> wrote:
> Dear,
> I think database has its own operation journal, and different journal
> filesystem does give different performance. So if I put database file on a
> non-journal filesystem, would it be safe? Does this like using a raw device?

you can put pg_xlog on a non-journaling fs I believe, but the main
data dir needs to be journaled.

Me, I put them both on journaled file systems.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Magoffin 2007-12-12 04:49:24 Re: how to create aggregate xml document in 8.3?
Previous Message Magicloud Wang 2007-12-12 03:55:36 Would it be OK if I put db file on a ext2 filesystem?