From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Justin <justin(at)emproshunts(dot)com> |
Cc: | Craig James <craig_james(at)emolecules(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 |
Date: | 2008-03-17 18:12:03 |
Message-ID: | B18EFFDB-D930-47AB-A0BF-2A4AAF1C4765@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 17-Mar-08, at 2:50 PM, Justin wrote:
>
>>
>> Just out of curiosity: Last time I did research, the word seemed to
>> be that xfs was better than ext2 or ext3. Is that not true? Why
>> use ext2/3 at all if xfs is faster for Postgres?
>>
>> Criag
>
> Ext2 vs XFS on my setup there is difference in the performance
> between the two file systems but its not OMG let switch. XFS did
> better then Ext2 only one time, then Ext2 won out by small margin at
> best was 6%. the other test ran at 3 to 4% better than XFS
> performance.
>
> XFS has journaling so it should be safer. I think i may stick with
> XFS as it has journaling
>
> One thing i think is clear don't use ext3 it just kills performance
> by factors not small percents
>
> here is article i found on XFS http://linux-xfs.sgi.com/projects/xfs/papers/xfs_white/xfs_white_paper.html
>
> I hope this is helpful to people. I know the process has taught me
> new things, and thanks to those that helped me out.
>
> Before i throw this sever into production any one else want
> performance numbers.
>
> C:\Program Files\PostgreSQL\8.3\bin>pgbench -c 10 -t 40000 -v -h
> 192.168.1.9 -U
> postgres play
> Password:
> starting vacuum...end.
> starting vacuum accounts...end.
> transaction type: TPC-B (sort of)
> scaling factor: 100
> number of clients: 10
> number of transactions per client: 40000
> number of transactions actually processed: 400000/400000
> tps = 2181.512770 (including connections establishing)
> tps = 2187.107004 (excluding connections establishing)
>
2000 tps ??? do you have fsync turned off ?
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2008-03-17 18:33:28 | Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 |
Previous Message | Peter Koczan | 2008-03-17 18:01:06 | Re: What is the best way to storage music files in Postgresql |