[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

Re: [GENERAL] PostgreSQL 8.3 with Java 7

2012-11-01 Thread Svancara, Randall
I would say upgrade to the latest. There are features and performance increases in the 9.x series. Randall Svancara High Performance Computing Systems Administrator Washington State University 509-335-3039 From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On