Skip site navigation (1) Skip section navigation (2)

Re: Raid 10 chunksize

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Raid 10 chunksize
Date: 2009-03-26 04:28:46
Message-ID: 49CB047E.3090909@paradise.net.nz (view raw or flat)
Thread:
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

In response to

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2009-03-26 04:37:00
Subject: Re: Raid 10 chunksize
Previous:From: Bryan MurphyDate: 2009-03-26 04:00:25
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group