Fw: Journaling file systems

> > 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(at)postgresql(dot)org
>