Re: Raw vs Filesystem

el_vigia_ec(at)hotmail(dot)com ("Jaime Casanova") asked:
> so, the real question is what is the best filesystem for optimal speed
> in postgresql?

The smart-alec answer would be... "Veritas, of course!"

But seriously, it depends on many factors you have not provided
information about.

-> Different operating systems support different filesystems; you
should probably specify what OS you are using.

-> Hardware choices have ENORMOUSLY more impact on speed than any
choice of filesystems.

If your hardware is too slow, changing filesystems will not help you.

And you would be _way_ better off with a filesystem that is 3% slower
if it improves reliability by a significant factor.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www3.sympatico.ca/cbbrowne/lsf.html
"We should start referring to processes which run in the background by
their correct technical name:... paenguins." -- Kevin M Bealer