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: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql 8.3 tps rate
Date: 2009-01-22 21:36:11
Message-ID: 530068a0901221336m29b37e1bqe530410c1855e07a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)gmail(dot)com> wrote:
> On 1/22/09, Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com> 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
>

Attachment: disk2.html
Description: text/html (2.9 KB)
Attachment: disk.html
Description: text/html (3.4 KB)

In response to

pgsql-performance by date

Next:From: David ReesDate: 2009-01-22 21:41:25
Subject: Re: postgresql 8.3 tps rate
Previous:From: Ibrahim HarraniDate: 2009-01-22 21:27:36
Subject: Re: postgresql 8.3 tps rate

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