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 pgbench.
The bonnie command:
bonnie++ -u miki -b -d /data/bonnie/ -s 6080:8k -m pr1
pgbench commands:
pgbench -i -s 10 test
pgbench -c
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Ben-Nes
Sent: Wednesday, September 14, 2005 10:58 AM
To: [EMAIL PROTECTED]
Cc: linux-il@linux.org.il
Subject: Re: sys / db performance block size
After a week of testing i decided to go with JFS as the FS
After few test, not certain yet i found *Surprise*Surprise* ext3 is
quite fast especially when using dir_index
This is the command i issued. i was recommended going on Journal size of
400 ( not really sure why ).
mke2fs -j -J size=400 -O dir_index -T largefile /dev/sdb1
testing it with
On 9/5/05, Michael Ben-Nes [EMAIL PROTECTED] wrote:
Im setting up a Postgresql sql server on IBM x345, dual xeon, raid1 ( 2
disks ), raid10 ( 4 disks ).
The db data will be stored on the RAID10 and will consist mostly of
product table of 5 mil rows and keywords table with 60 mil rows.
..
FS.
Regards,
tzahi.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Ben-Nes
Sent: Monday, September 05, 2005 10:00 AM
To: linux-il@linux.org.il
Subject: sys / db performance block size
Hi
Im setting up a Postgresql sql