From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: User concurrency thresholding: where do I look?
Date: Thu, 19 Jul 2007 15:04:44 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0707191449260.28215@westnet.com> (raw)
In-Reply-To: <200707190828.59088.josh@agliodbs.com>
References: <200707190828.59088.josh@agliodbs.com>
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@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com
Subject: Re: User concurrency thresholding: where do I look?
In-Reply-To: <Pine.GSO.4.64.0707191449260.28215@westnet.com>
* 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