....
Of more interest would be a test which involved large files with lots
of seeks all around (something like bonnie++ should do that).
....

Here's the bonnie++ numbers for the RAID 5 x 6 disks. I believe this was
with write-through and 64k striping. I plan to run a few others with
different block sizes and larger files- I'd be happy to send out a link
to the list when I get a chance to post them somewhere. I've also been
running some basic tests with pgbench just to help jumpstart customizing
postgresql.conf, so that might be of interest too.

bash-2.05b$ bonnie++ -d bonnie -s 1000:8k
Version 1.93c ------Sequential Output------ --Sequential Input-
--Random-
Concurrency 1 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--
--Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP
/sec %CP
1000M 587 99 246900 71 225124 76 1000 99 585723 99
8573 955
Latency 14367us 50829us 410ms 57965us 1656us
432ms
Version 1.93c ------Sequential Create------ --------Random
Create--------
-Create-- --Read--- -Delete-- -Create-- --Read---
-Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
/sec %CP
16 28192 91 +++++ +++ +++++ +++ 26076 89 +++++ +++
+++++ +++
Latency 25988us 75us 37us 24756us 36us
41us
1.93c,1.93c,
,1,1155223901,1000M,,587,99,246900,71,225124,76,10 00,99,585723,99,8573,9
55,16,,,,,28192,91,+++++,+++,+++++,+++,26076,89,++ +++,+++,+++++,+++,1436
7us,50829us,410ms,57965us,1656us,432ms,25988us,75u s,37us,24756us,36us,41
us

....
Thanks for sharing your numbers.
....

You're welcome- I prefer to see actual numbers rather than people simply
stating that RAID controller X is better, so hopefully more people will
do the same.

- Bucky

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Bucky,

I see you are running bonnie++ version 1.93c. The numbers it reports are
very different from version 1.03a, which is the one everyone runs - can you
post your 1.03a numbers from bonnie++?

- Luke


On 8/14/06 4:38 PM, "Bucky Jordan" <bjordan@lumeta.com> wrote:

> ...
> Of more interest would be a test which involved large files with lots
> of seeks all around (something like bonnie++ should do that).
> ...
>
> Here's the bonnie++ numbers for the RAID 5 x 6 disks. I believe this was
> with write-through and 64k striping. I plan to run a few others with
> different block sizes and larger files- I'd be happy to send out a link
> to the list when I get a chance to post them somewhere. I've also been
> running some basic tests with pgbench just to help jumpstart customizing
> postgresql.conf, so that might be of interest too.
>
> bash-2.05b$ bonnie++ -d bonnie -s 1000:8k
> Version 1.93c ------Sequential Output------ --Sequential Input-
> --Random-
> Concurrency 1 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--
> --Seeks--
> Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP
> /sec %CP
> 1000M 587 99 246900 71 225124 76 1000 99 585723 99
> 8573 955
> Latency 14367us 50829us 410ms 57965us 1656us
> 432ms
> Version 1.93c ------Sequential Create------ --------Random
> Create--------
> -Create-- --Read--- -Delete-- -Create-- --Read---
> -Delete--
> files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
> /sec %CP
> 16 28192 91 +++++ +++ +++++ +++ 26076 89 +++++ +++
> +++++ +++
> Latency 25988us 75us 37us 24756us 36us
> 41us
> 1.93c,1.93c,
> ,1,1155223901,1000M,,587,99,246900,71,225124,76,10 00,99,585723,99,8573,9
> 55,16,,,,,28192,91,+++++,+++,+++++,+++,26076,89,++ +++,+++,+++++,+++,1436
> 7us,50829us,410ms,57965us,1656us,432ms,25988us,75u s,37us,24756us,36us,41
> us
>
> ...
> Thanks for sharing your numbers.
> ...
>
> You're welcome- I prefer to see actual numbers rather than people simply
> stating that RAID controller X is better, so hopefully more people will
> do the same.
>
> - Bucky
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

....
I see you are running bonnie++ version 1.93c. The numbers it reports are
very different from version 1.03a, which is the one everyone runs - can
you
post your 1.03a numbers from bonnie++?
....

Luke,

Thanks for the pointer. Here's the 1.03 numbers, but at the moment I'm
only able to run them on the 6 disk RAID 5 setup (128k stripe, writeback
enabled since the Perc5 does have a battery backed cache).

bonnie++ -d bonnie -s 1000:8k
Version 1.03 ------Sequential Output------ --Sequential Input-
--Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block--
--Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP
/sec %CP
1000M 155274 95 265359 44 232958 52 166884 99
1054455 99 +++++ +++
------Sequential Create------ --------Random
Create--------
-Create-- --Read--- -Delete-- -Create-- --Read---
-Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
/sec %CP
16 +++++ +++ +++++ +++ +++++ +++ 30550 88 +++++ +++
+++++ +++
,1000M,155274,95,265359,44,232958,52,166884,99,105 4455,99,+++++,+++,16,+
++++,+++,+++++,+++,+++++,+++,30550,88,+++++,+++,++ +++,+++

- Bucky

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Bucky,

I don't know why I missed this the first time - you need to let bonnie++
pick the file size - it needs to be 2x memory or the results you get will
not be accurate.

In this case you've got a 1GB file, which nicely fits in RAM.

- Luke


On 8/15/06 6:56 AM, "Bucky Jordan" <bjordan@lumeta.com> wrote:

> ...
> I see you are running bonnie++ version 1.93c. The numbers it reports are
> very different from version 1.03a, which is the one everyone runs - can
> you
> post your 1.03a numbers from bonnie++?
> ...
>
> Luke,
>
> Thanks for the pointer. Here's the 1.03 numbers, but at the moment I'm
> only able to run them on the 6 disk RAID 5 setup (128k stripe, writeback
> enabled since the Perc5 does have a battery backed cache).
>
> bonnie++ -d bonnie -s 1000:8k
> Version 1.03 ------Sequential Output------ --Sequential Input-
> --Random-
> -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--
> --Seeks--
> Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP
> /sec %CP
> 1000M 155274 95 265359 44 232958 52 166884 99
> 1054455 99 +++++ +++
> ------Sequential Create------ --------Random
> Create--------
> -Create-- --Read--- -Delete-- -Create-- --Read---
> -Delete--
> files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
> /sec %CP
> 16 +++++ +++ +++++ +++ +++++ +++ 30550 88 +++++ +++
> +++++ +++
> ,1000M,155274,95,265359,44,232958,52,166884,99,105 4455,99,+++++,+++,16,+
> ++++,+++,+++++,+++,+++++,+++,30550,88,+++++,+++,++ +++,+++
>
> - Bucky
>



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly