Re: postgresql 8.3 tps rate

Hi David,

$ I run the test again with the following options. Also I added the
html output of the result.

$ bonnie++ -u pgsql -n 128 -r 2048 -s 4096 -x 1
Using uid:70, gid:70.
Writing with putc()...done
Writing intelligently...done
Rewriting...done
Reading with getc()...done
Reading intelligently...done
start 'em...done...done...done...
Create files in sequential order...done.
Stat files in sequential order...done.
Delete files in sequential order...done.
Create files in random order...done.
Stat files in random order...done.
Delete files in random order...done.
myserver,4G,8028,5,8118,1,5079,1,36055,28,32950,3,128.4,0,128,5620,11,142084,99,88739,99,12880,26,109150,99,90362,99

What about this result?
This is a intel server with onboard raid. I will check raid
configuration again tomorrow. Especially Write Cache and Read Ahead
values mentioned at
http://www.intel.com/support/motherboards/server/sb/CS-021019.htm

On Thu, Jan 22, 2009 at 11:41 PM, David Rees <drees76(at)gmail(dot)com> wrote:
> On Thu, Jan 22, 2009 at 1:27 PM, Ibrahim Harrani
> <ibrahim(dot)harrani(at)gmail(dot)com> wrote:
>> Version 1.93d ------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
>> myserver 300M 391 97 9619 1 8537 2 673 99 +++++ +++ 1196 16
>> Latency 211ms 388ms 325ms 27652us 722us 6720ms
>> Version 1.93d ------Sequential Create------ --------Random Create--------
>> myserver -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
>> files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
>> 16 9004 25 +++++ +++ +++++ +++ 8246 20 +++++ +++ +++++ +++
>> Latency 592ms 208us 102us 673ms 179us 100us
>
> You should be testing bonnie with a file size that is at least double
> the amount of memory in your machine - in this case, 4GB files, not
> 300MB files.
>
>> When I compare my bonnie++ result with the one at
>> http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm,
>> It seems that there is something wrong with the disks!?
>
> Yes, your machine appears to be very slow. You should be able to
> write in the order of 30-50MB/s+ and read in the order of 40-80MB/s+.
> Random IO should be in the 200 tps range for a 7200rpm SATA RAID1.
>
> -Dave
>