Home > mailing lists

How Many PG_Locks are considered too many - Mailing list pgsql-general

From	Renato Oliveira
Subject	How Many PG_Locks are considered too many
Date	July 30, 2015 13:13:34
Msg-id	387405ED5B94BF42B91A9AB5BB14498E53A61241@ccpexch05.cantab.local Whole thread Raw
Responses	Re: [ADMIN] How Many PG_Locks are considered too many (Peter Eisentraut <peter_e@gmx.net>)
List	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

From: Alban Hertroys
Date: 30 July 2015, 12:57:36
Subject: Re: Question about copy from with timestamp format

From: Rowan Collins
Date: 30 July 2015, 15:35:59
Subject: Exclusively locking parent tables while disinheriting children.