Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: User concurrency thresholding: where do I look?
- From: Greg Smith <gsmith(at)gregsmith(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: User concurrency thresholding: where do I look?
- Date: Thu, 19 Jul 2007 15:04:44 -0400 (EDT)
On Thu, 19 Jul 2007, Josh Berkus wrote:
What seems to be happening is that at some specific number of connections average throughput drops 30% and response time quadruples or worse.
Could you characterize what each connection is doing and how you're generating the load? I don't know how productive speculating about the cause here will be until there's a test script available so other people can see where the tipping point is on their system.
-- * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
- References:
- User concurrency thresholding: where do I look?
- From: Josh Berkus
- User concurrency thresholding: where do I look?
- Prev by Date: Re: User concurrency thresholding: where do I look?
- Next by Date: Improving select peformance
- Previous by thread: Re: User concurrency thresholding: where do I look?
- Next by thread: Is it possible to know where is the "deadlock"
- Indexes: