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?
Список 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 по дате отправления: