Re: [GENERAL] Postgresql ShareLock problems.

2012-11-01 Thread Jeff Janes
On Thu, Nov 1, 2012 at 12:43 PM, Svancara, Randall wrote: > We are using a third party monitoring solution called Zabbix with Postgresql > 9.1.We are observing lots of sharelock problems possibly as a result of > multiple, concurrent updates to the specific table called items. > > > First of all,

[GENERAL] Postgresql ShareLock problems.

2012-11-01 Thread Svancara, Randall
We are using a third party monitoring solution called Zabbix with Postgresql 9.1.We are observing lots of sharelock problems possibly as a result of multiple, concurrent updates to the specific table called items. First of all, what can I do to reduce lock contention in Postgresql? Surely some