Block Size and various FS settings
От | Michael Ben-Nes |
---|---|
Тема | Block Size and various FS settings |
Дата | |
Msg-id | 431B1CF3.7020105@canaan.co.il обсуждение исходный текст |
Ответы |
Re: Block Size and various FS settings
|
Список | 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 --------------------------
В списке pgsql-general по дате отправления: