Message-
> 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
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 1
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 bonn
First, its better to ask the experts on this matters at
pgsql-general@postgresql.org
It is not definitive that for postgresql you'd better set
8kb block size since the OS already coalleses the files close
together anyway and there is no guarentee the page will be aligned
to the hardware block size
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
