Fw: Journaling file systems - Mailing list pgsql-admin

From Radu-Adrian Popescu
Subject Fw: Journaling file systems
Date
Msg-id 005e01c1bee6$e5c764d0$0600a8c0@rpopescu
Whole thread Raw
List pgsql-admin
> > Friends,
> > I'm wondering if a journaling file system, like ext3, will make much
> > difference with the speed or reliability of PostgreSQL?  Is it worth the
> > work to switch over?

 To the best of my knowledge, EXT3 and XFS and the like are metadata
 journaling filesystems.
 This means that only the file's metadata is journaled, and not the
contents.
 I strongly reccomend using XFS  (or EXT3) as it has little overhead and
 large benefits, and
 you don't need to worry about performance issues. If you do, invest in
 better (SCSI) hardware, don't
 dissmiss the filesystem.
 Hope it helps,

 Radu-Adrian Popescu
 CSA, DBA, Developer
 www.aldratech.com

> > Thanks,
> > Peter Darley
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-admin by date:

Previous
From: "Peter Darley"
Date:
Subject: Re: Journaling file systems
Next
From: "Rohit Dewan"
Date:
Subject: Minimum database size