How to track down locks held by recovery process on a slave?

Поиск
Список
Период
Сортировка
От Amador Alvarez
Тема How to track down locks held by recovery process on a slave?
Дата
Msg-id CA+vGRtg+8wNugVByhLrhZX=SBnb7k9b9zZfOMPNo7nAEoRAu6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to track down locks held by recovery process on a slave?  (reiner peterke <zedaardv@drizzle.com>)
Список pgsql-admin
Дерево обсуждения
Hi there,

I am using a postgres 9.2 slave for some reports and I noticed that sometimes they are held up because certain activity on the master like vacuums can affect long queries on a slave .

Looking at pg_locks view , I can see that the recovering process on the slave is holding some AccessExclusiveLock locks on relations which numbers that do not mach any pg_class.oid.

Any idea How could I find out which relations are locked by the recovering process?


Thanks in advance,
A.A.

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

Предыдущее
От: Mike Broers
Дата:
Сообщение: Re: ERROR: could not open file "base/125542/12631" Corruption?
Следующее
От: reiner peterke
Дата:
Сообщение: Re: How to track down locks held by recovery process on a slave?