On Wed, 2006-09-06 at 22:12 -0400, Christopher Browne wrote:
> > Can you elaborate a little? Which filesystems have been problematic?
> > Which filesystems are you more confident in?
>
> Well, more or less *all* of them, on AMD-64/Linux.
>
> The "pulling the fibrechannel cable" test blew them all. XFS, ext3,
> JFS. ReiserFS was, if I recall correctly, marginally better, but only
> marginally.
>
> On AIX, we have seen JFS2 falling over when there were enough levels
> of buffering in the way on disk arrays.
>
Well, that's interesting. I suppose I can't count on the filesystem as
much as I thought. Are you implying that the filesystems aren't ready on
64-bit? Is it more of a hardware issue (a controller lying about the
security of the write)? Any comments on FreeBSD/UFS+SU? I would expect
UFS+SU to have similar issues, since it depends on write ordering also.
What do you do for better data security (aside from the obvious "don't
pull cables")?
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
