From: Mark Kirkwood <markir@paradise.net.nz>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Raid 10 chunksize
Date: Thu, 26 Mar 2009 17:28:46 +1300
Message-ID: <49CB047E.3090909@paradise.net.nz> (raw)
In-Reply-To: <49C9A314.6050302@paradise.net.nz>
References: <49C98433.5080709@paradise.net.nz>
<dcc563d10903241911p29f604vfd9025a106d0eac3@mail.gmail.com>
<49C9A314.6050302@paradise.net.nz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz
Subject: Re: Raid 10 chunksize
In-Reply-To: <49CB047E.3090909@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox