Re: Raid 10 chunksize

Mark Kirkwood <markir@paradise.net.nz>

From: Mark Kirkwood <markir@paradise.net.nz>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2009-03-26T04:28:46Z
Lists: pgsql-performance
I wrote:
> Scott Marlowe wrote:
>
>>
>> Can you try changing the chunksize on the test box you're testing on
>> to see if that helps?
>>
>>   
>
> Yes - or I am hoping to anyway (part of posting here was to collect 
> some outside validation for the idea). Thanks for your input!
>

Rebuilt with 64K chunksize:

transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 24
number of transactions per client: 12000
number of transactions actually processed: 288000/288000
tps = 866.512162 (including connections establishing)
tps = 866.651320 (excluding connections establishing)


So 64K looks quite a bit better. I'll endeavor to try out 256K next week 
too.

Mark