Re: [GENERAL] Block Size and various FS settings

2005-09-14 Thread Marco Colombo
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://

Re: [GENERAL] Block Size and various FS settings

2005-09-14 Thread Michael Ben-Nes
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 wrot

[GENERAL] Block Size and various FS settings

2005-09-04 Thread Michael Ben-Nes
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