Re: User concurrency thresholding: where do I look?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: User concurrency thresholding: where do I look?
Дата
Msg-id 200707311433.20568.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: User concurrency thresholding: where do I look?  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: User concurrency thresholding: where do I look?  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Semantics of PostgreSQL Server Log Stats
Следующее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: User concurrency thresholding: where do I look?