Re: Optimizing GetRunningTransactionLocks()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizing GetRunningTransactionLocks()
Дата
Msg-id 8583.1320093798@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Optimizing GetRunningTransactionLocks()  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> My list of things to do included optimising
> GetRunningTransactionLocks(), run once per checkpoint.

> I was thinking I needed to try harder to avoid acquiring LWlocks on
> all the lock partitions.

> ISTM that I don't need to do this - lwlocks on lock partitions are
> almost never contended now, so this should go much faster than before.

> Any thoughts? Do we think it would benefit from further tweaking?

> I'll assume not unless I hear from somebody with a different idea.

ISTM that some evidence of a problem should be acquired before expending
sweat on a solution ... have you seen evidence that this creates any
real issue?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Optimizing GetRunningTransactionLocks()
Следующее
От: Scott Mead
Дата:
Сообщение: IDLE in transaction introspection