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

Re: Pooling in Core WAS: Need help in performance tuning.

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: greg(at)2ndquadrant(dot)com, Kevin(dot)Grittner(at)wicourts(dot)gov, matthew(at)flymine(dot)org, 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-19 02:36:09
Message-ID: AANLkTilggKbmC9H7wlhlCdQFm5RJth1-9DPF8GoLV9Hm@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
 Thanks for the thought but it (-C) does not work .

>
>
> BTW, I think you should use -C option with pgbench for this kind of
> testing. -C establishes connection for each transaction, which is
> pretty much similar to the real world application which do not use
> connection pooling. You will be supprised how PostgreSQL connection
> overhead is large.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>

In response to

Responses

pgsql-performance by date

Next:From: Tatsuo IshiiDate: 2010-07-19 02:50:34
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Previous:From: Tatsuo IshiiDate: 2010-07-19 02:16:04
Subject: Re: Pooling in Core WAS: Need help in performance tuning.

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