Re: Postgres log configuration for locking

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Re: Postgres log configuration for locking
Дата
Msg-id 868uiofms1.fsf@jerry.enova.com
обсуждение исходный текст
Ответ на Postgres log configuration for locking  (Raj Gandhi <raj01gandhi@gmail.com>)
Список pgsql-admin
Raj Gandhi <raj01gandhi@gmail.com> writes:

> I’m using Postgres 9.1 and enabled the log configuration param ‘log_lock_waits’.
>  
> However, it only logs the session which is waiting for the lock longer than ‘deadlock_timeout’. It doesn’t log
thesession which acquired the lock?  
>  
> Is there a way to log the session that acquired the lock along with the session which is waiting for the lock?

Do you assume there is but 1 single session blocking the waiter?

False in cases where some N number of sessions are all holding less
invasive locks and you are pending on a heavier one.

To wit; share locks granted and an exclusive locker pending.

The question in regards to whether it's possible to  log more info
here in any case  isn't something I can answer personally.

HTH


>  
> Thanks,
> Raj
>
>  
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


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

Предыдущее
От: Raj Gandhi
Дата:
Сообщение: Postgres log configuration for locking
Следующее
От: Khangelani Gama
Дата:
Сообщение: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams