| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Matthew Wakeling <matthew(at)flymine(dot)org>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Pooling in Core WAS: Need help in performance tuning. |
| Date: | 2010-07-18 17:25:47 |
| Message-ID: | 4C43391B.1040600@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rajesh Kumar Mallah wrote:
> the no of clients was 10 ( -c 10) carrying out 10000 transactions
> each (-t 10000) .
> pgbench db was initilised with scaling factor -s 100.
>
> since client count was less there was no queuing of requests in pgbouncer
> i would prefer to say it was in 'passthrough' mode.
Of course pgbouncer is going decrease performance in this situation.
You've added a whole layer to things that all traffic has to pass
through, without a setup that gains any benefit from the connection
pooling. Try making the client count 1000 instead if you want a useful
test.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2010-07-18 17:47:58 | Re: Pooling in Core WAS: Need help in performance tuning. |
| Previous Message | Rajesh Kumar Mallah | 2010-07-18 17:09:13 | Re: Pooling in Core WAS: Need help in performance tuning. |