Re: Recomended FS

Hi Ben,

You asked so here's my take on the subject, but I've gotta say that you 
can't go far wrong with reading Bruce Momjian's paper at:

http://www.ca.postgresql.org/docs/momjian/hw_performance/

But with that aside.

1. Unless your doing major league DB stuff, the FS should make more than 
marginal difference, if it's Journaled then it's good.  You can take all 
the time benchmarking that you want, just be sure your ROI is worth the 
time you invest.  My favourite fs is Reiser, but in the cold light of 
day, ext3 is supported in more places.  My first choice is Reiser, since 
I used it even when it was "unstable" on production servers and it never 
let me down.  I often use one or the other.

2.  Bruce's article really is good for this question, but in a nutshell 
you need to get as much of the DB as close to the CPU as possible.  As 
with any  serious application, you can't beat a good L1/L2 cache, then 
plenty of RAM/Memory ... DBs yum RAM, the more the merrier.  Lastly fast 
and wide disc access, remember disk access will be the slowest part of 
the system, and in an ideal world you'd fit nearly all of your DB in RAM 
if it was practical and safe.

You'd probably gain more from taking the time to really ensure that your 
DB is designed flawlessly, and all your indexes are where they're 
needed.  All of the basics come into play, but a well built RDBMS system 
is greater than the sum of its parts.

For further reading check out:

http://www.argudo.org/postgresql/soft-tuning.html

It all adds up!!.

Good Luck

Tony.



Ben-Nes Michael wrote:

>Hi
>
>I'm upgrading the DB sever hardware and also the Linux OS.
>
>My Questions are:
>
>1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed,
>efficiency )
>2. What is the most importent part in the Hardware ? fast HD, alot of mem,
>or maybe strong cpu ?
>
>Thanks in Advance
>
>--------------------------
>Canaan Surfing Ltd.
>Internet Service Providers
>Ben-Nes Michael - Manager
>Tel: 972-4-6991122
>Fax: 972-4-6990098
>http://www.canaan.net.il
>--------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>  
>