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

Re: postgresql 8.3 tps rate

From: Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com>
To: David Rees <drees76(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql 8.3 tps rate
Date: 2009-01-22 22:29:57
Message-ID: 530068a0901221429gc913731kd4ab1750fa1c5cfb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
>

Attachment: disk3.html
Description: text/html (2.9 KB)

In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2009-01-22 22:44:08
Subject: Re: postgresql 8.3 tps rate
Previous:From: Kenneth MarshallDate: 2009-01-22 22:03:33
Subject: Re: caching indexes and pages?

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