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

Re: postgresql 8.3 tps rate

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql 8.3 tps rate
Date: 2009-01-22 16:36:36
Message-ID: b41c75520901220836n359e204du56a53921ad0576a4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> I am running postgresql 8.3.5 on FreeBSD with Dual core Intel(R)
> Xeon(R) CPU 3065  @ 2.33GHz, 2GB RAM and Seagate Technology -
> Barracuda 7200.10 SATA 3.0Gb/ (RAID 1).
>
> I made several benchmark test with pgbench, TPS rate is almost 40 +/- 5.
> $ pgbench -i pgbench -s 50 -U pgsql
>
> [pgsql(at)$ pgbench -c 200 -t 2 -U pgsql -d pgbench
>
> transaction type: TPC-B (sort of)
> scaling factor: 10
> number of clients: 200
> number of transactions per client: 2
> number of transactions actually processed: 400/400
> tps = 39.044088 (including connections establishing)
> tps = 41.528795 (excluding connections establishing)
>
> [pgsql(at)$ pgbench -c 100 -t 5 -U pgsql -d pgbench
>
> transaction type: TPC-B (sort of)
> scaling factor: 10
> number of clients: 100
> number of transactions per client: 5
> number of transactions actually processed: 500/500
> tps = 30.162271 (including connections establishing)
> tps = 30.643256 (excluding connections establishing)
>
> Is this rate is normal or not? What can I do to improve tps and insert
> performance?

You add more and faster disks.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.

Shakespeare

In response to

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2009-01-22 16:37:47
Subject: Re: postgresql 8.3 tps rate
Previous:From: Robert HaasDate: 2009-01-22 16:27:31
Subject: Re: Slow HashAggregate : How to optimize ?

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