el_vigia_ec@hotmail.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