Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: User concurrency thresholding: where do I look?
- From: Josh Berkus <josh(at)agliodbs(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: User concurrency thresholding: where do I look?
- Date: Tue, 31 Jul 2007 14:33:20 -0700
Simon, > Well thats pretty weird. That code path clearly only happens once per > transaction and ought to be fast. The other code paths that take > ProcArrayLock like TransactionIdIsInProgress() and GetSnapshotData() > ought to spend more time holding the lock. Presumably you are running > with a fair number of SERIALIZABLE transactions? Given that this is TPCC-analog, I'd assume that we are. Jignesh? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco
- Follow-Ups:
- Re: User concurrency thresholding: where do I look?
- From: Jignesh K. Shah
- Re: User concurrency thresholding: where do I look?
- References:
- User concurrency thresholding: where do I look?
- From: Josh Berkus
- Re: User concurrency thresholding: where do I look?
- From: Jignesh K. Shah
- Re: User concurrency thresholding: where do I look?
- From: Simon Riggs
- User concurrency thresholding: where do I look?
- Prev by Date: Re: Semantics of PostgreSQL Server Log Stats
- Next by Date: Re: User concurrency thresholding: where do I look?
- Previous by thread: Re: User concurrency thresholding: where do I look?
- Next by thread: Re: User concurrency thresholding: where do I look?
- Indexes: