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  (Michael Ben-Nes <miki@canaan.co.il>)
Список 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 по дате отправления:

Предыдущее
От: Douglas McNaught
Дата:
Сообщение: Re: Query questions
Следующее
От: Lexington Luthor
Дата:
Сообщение: Unicode limits