From: | Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Block Size and various FS settings |
Date: | 2005-09-04 16:12:35 |
Message-ID: | 431B1CF3.7020105@canaan.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Everyone
Im setting up a machine that will host postgres 8.0.3.
The main tables will be:
Product - around 5 million records.
keywords - around 80 million records.
The machine that will host it is IBM x345 with two XEON, 3GB RAM,
ServeRAID 6i and 6 15K HD.
The OS ( Centos4.1 ) will be installed on the RAID 1 ( 2 HD )
The PG Data will be initialized on RAID 10 ( 4 HD ).
should I stick to the default postgres 8192 block size ?
If so, the same 8192 should be applied to the Reiserfs block size ?
and what about the RAID hardware striping size ?
Read on the net that pg 8k, reiserfs 8k and Raid strip of 64k will be
the best.
http://forums.devshed.com/archive/t-33101/Any-RAID-striping-recommendations
Is it safe to use noatime, nodirtime, notail on the partion of PG data ?
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Lexington Luthor | 2005-09-04 17:01:37 | Unicode limits |
Previous Message | Douglas McNaught | 2005-09-04 14:07:27 | Re: Query questions |