> > 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 [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
