On Tue, Mar 21, 2006 at 06:01:58AM -0600, Jim C. Nasby wrote:
On Tue, Mar 21, 2006 at 12:56:18PM +0100, Steinar H. Gunderson wrote:
For the record, that's the wrong way round. For the data partitioning
metadata journaling is enough, and for the WAL partition you don't need any
FS journaling at all.
Are you sure?
Yes. :) You actually shouldn't need metadata journaling in either
case--fsck will do the same thing. But fsck can take a *very* long time
on a large paritition, so for your data partition the journaling fs is a
big win. But your wal partition isn't likely to have very many files
and should fsck in a snap, and data consistency is taken care of by
synchronous operations. (Which is the reason you really don't need/want
data journalling.)
Mike Stone
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
