This is the another bonnie++ test result with version 1.03
Delete files in random order...done.
Version 1.03e ------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
myserver 300M 13150 7 12713 1 13067 4 72426 53 +++++ +++ +++++ +++
------Sequential Create------ --------Random Create--------
-Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 1048 2 +++++ +++ 2322 3 985 2 +++++ +++ 1797 3
myserver,300M,13150,7,12713,1,13067,4,72426,53,+++++,+++,+++++,+++,16,1048,2,+++++,+++,2322,3,985,2,+++++,+++,1797,3
Also I attached bon_csv2html output for both version of bonnie++
Thanks in advance.
On Thu, Jan 22, 2009 at 7:14 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
> On 1/22/09, Ibrahim Harrani <ibrahim.harrani@xxxxxxxxx> wrote:
>>
>> Is this rate is normal or not? What can I do to improve tps and insert
>> performance?
>>
>> postgresql.conf
>>
>> shared_buffers = 800MB # min 128kB or max_connections*16kB
>> work_mem = 2MB # min 64kB
>> maintenance_work_mem = 32MB # min 1MB
>
> I would raise maintenance_work_mem, although it's unrelated to your issue.
>
>> max_connections = 600 # (change requires restart)
>> max_fsm_relations = 2000 # min 100, ~70 bytes each
>> synchronous_commit = off
>
> Something is very wrong. 40tps is low, even for sata raid 1, but
> absolutely terrible with synchronous_commit = off. This suggests you
> are problems are read related and not sync related. Can you rerun
> pgbench using the custom sql feature, passing insert statements?
>
> Are you sure nothing else is going on/wrong with the box? Can we see a
> bonnie++ run?
>
> merlin
>
Title: Bonnie++ Benchmark results
| Version 1.93d | Sequential Output | Sequential Input | Random Seeks | Sequential Create | Random Create | |||||||||||||||||||||||
| Concurrency | Size | Per Char | Block | Rewrite | Per Char | Block | Num Files | Create | Read | Delete | Create | Read | Delete | |||||||||||||||
| K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | /sec | % CPU | /sec | % CPU | /sec | % CPU | /sec | % CPU | /sec | % CPU | /sec | % CPU | /sec | % CPU | |||||
| myserver | 1 | 300M | 391 | 97 | 9619 | 1 | 8537 | 2 | 673 | 99 | +++++ | +++ | 1196 | 16 | 16 | 9004 | 25 | +++++ | +++ | +++++ | +++ | 8246 | 20 | +++++ | +++ | +++++ | +++ | |
| myserver | Latency | 211ms | 388ms | 325ms | 27652us | 722us | 6720ms | Latency | 592ms | 208us | 102us | 673ms | 179us | 100us | ||||||||||||||
| Sequential Output | Sequential Input | Random Seeks |
Sequential Create | Random Create | ||||||||||||||||||||||
| Size:Chunk Size | Per Char | Block | Rewrite | Per Char | Block | Num Files | Create | Read | Delete | Create | Read | Delete | ||||||||||||||
| K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | K/sec | % CPU | / sec | % CPU | / sec | % CPU | / sec | % CPU | / sec | % CPU | / sec | % CPU | / sec | % CPU | / sec | % CPU | |||
| myserver | 300M | 13150 | 7 | 12713 | 1 | 13067 | 4 | 72426 | 53 | +++++ | +++ | +++++ | +++ | 16 | 1048 | 2 | +++++ | +++ | 2322 | 3 | 985 | 2 | +++++ | +++ | 1797 | 3 |
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
