Обсуждение: Block Size and various FS settings
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 --------------------------
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 --------------------------
On Wed, 2005-09-14 at 11:25 +0300, Michael Ben-Nes wrote: > 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 Have you tried data=journal / data=ordered / data=writeback mount options for ext3? If so, did they make any difference? .TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ Colombo@ESI.it