From: ktm@rice.edu <ktm@rice.edu>
To: Anne Rosset <arosset@collab.net>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Deterioration in performance when query executed in multi threads
Date: Wed, 1 May 2013 11:26:50 -0500
Message-ID: <20130501162650.GI27807@aart.rice.edu> (raw)
In-Reply-To: <9A6B86D66BD3C2438AFACFA09354890F20A2E06C@EXCH01.sp.corp.collab.net>
References: <9A6B86D66BD3C2438AFACFA09354890F20A2DF6D@EXCH01.sp.corp.collab.net>
<20130501141236.GG27807@aart.rice.edu>
<9A6B86D66BD3C2438AFACFA09354890F20A2E06C@EXCH01.sp.corp.collab.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On Wed, May 01, 2013 at 04:07:55PM +0000, Anne Rosset wrote:
> Hi Ken,
> Thanks for your answer. My test is actually running with jboss 7/jdbc and the connection pool is defined with min-pool-size =10 and max-pool-size=400.
>
> Why would you think it is an issue with the connection pool?
>
> Thanks,
> Anne
>
Hi Anne,
You want to be able to run as many jobs productively at once as your hardware is
capable of supporting. Usually something starting a 2 x number of CPUs is best.
If you make several runs increasing the size of the pool each time, you will
see a maximum throughput somewhere near there and then the performance will
decrease as you add more and more connections. You can then use that sweet spot.
Your test harness should make that pretty easy to find.
Regards,
Ken
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, arosset@collab.net
Subject: Re: Deterioration in performance when query executed in multi threads
In-Reply-To: <20130501162650.GI27807@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox