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