Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 200707311433.20568.josh@agliodbs.com
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: User concurrency thresholding: where do I look?  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Semantics of PostgreSQL Server Log Stats
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: User concurrency thresholding: where do I look?