Re: Raw vs Filesystem - Mailing list pgsql-admin

From Christopher Browne
Subject Re: Raw vs Filesystem
Date
Msg-id m3vfkn2dcv.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to Re: Raw vs Filesystem  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
Responses Re: Raw vs Filesystem  (Torsten Neuer <tneuer@inwise.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Use 7.4.1's pg_dump in 7.2.4?
Next
From: Christopher Browne
Date:
Subject: Re: Raw devices vs. Filesystems