How Many PG_Locks are considered too many

Поиск

Список

Период

Сортировка

От	Renato Oliveira
Тема	How Many PG_Locks are considered too many
Дата	30 июля 2015 г. 13:13:34
Msg-id	387405ED5B94BF42B91A9AB5BB14498E53A61241@ccpexch05.cantab.local обсуждение исходный текст
Ответы	Re: [ADMIN] How Many PG_Locks are considered too many (Peter Eisentraut <peter_e@gmx.net>)
Список	pgsql-general

I have few questions, if anyone could help me, it will be very much appreciated.

We have a Nagios plugin, which monitors pg_locks and almost daily we see 3000 to 40000 pg_locks.

Can we just ignore them, can we let them grow without worrying?

How many pg_locks are considered unsafe for any given postgres server?

Thank you

Renato

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

От: Alban Hertroys
Дата: 30 июля 2015 г., 12:57:36
Сообщение: Re: Question about copy from with timestamp format

От: Rowan Collins
Дата: 30 июля 2015 г., 15:35:59
Сообщение: Exclusively locking parent tables while disinheriting children.