> 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.
PostgreSQL @ Sun
In response to
pgsql-performance by date
|Next:||From: Jignesh K. Shah||Date: 2007-07-31 21:46:26|
|Subject: Re: User concurrency thresholding: where do I look?|
|Previous:||From: Bruce Momjian||Date: 2007-07-31 18:22:50|
|Subject: Re: Semantics of PostgreSQL Server Log Stats|