Thread: Fw: Journaling file systems

Fw: Journaling file systems

From
"Radu-Adrian Popescu"
Date:
> > 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
>