Re: User concurrency thresholding: where do I look? - Mailing list pgsql-performance

From Gregory Stark
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 871wf39u2o.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Josh Berkus <josh@agliodbs.com> writes:
>
>> That's an interesting thought.  Let me check lock counts and see if this is
>> possibly the case.
>
> AFAIK you'd get hard failures, not slowdowns, if you ran out of lock
> space entirely

I assume you've checked the server logs and are sure that you aren't in fact
getting errors. I could, for example, envision a situation where a fraction of
the transactions are getting some error and those transactions are therefore
not being counted against the txn/s result.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: 8.2 -> 8.3 performance numbers
Next
From: Dan Harris
Date:
Subject: Simple query showing 270 hours of CPU time