Re: Block Size and various FS settings

After a week of testing i decided to go with JFS as the FS for Postgres.

im not an expert benchmarker so i hope i initiated the right parameters
in bonnie.


Any way here are the results of bonnie++ & pgbench:


http://www.canaan.co.il/users/miki/stats/stats.html


Cheers


Michael Ben-Nes wrote:

> 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
--------------------------