Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1 - Mailing list pgsql-general

From Tarabas
Subject Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1
Date
Msg-id 1854590392.20110607175013@tarabas.de
Whole thread Raw
In response to Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: [bulk] Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1  (Tarabas <tarabas@tarabas.de>)
List pgsql-general
Hi Scott,

SM> Snip.  Those are ALL either AccessShareLock (which is very low level
SM> and non-blocking) or virtual tx locks, which again don't block
SM> anything but their own transaction.  Nothing there screams "locks!"
SM> for a better view of locks and how they're blocking things you can use
SM> the queries from here: http://wiki.postgresql.org/wiki/Lock_Monitoring

Thank you, I will try that. I am currently using Hibernate 3.2 as a
Database-Layer but with an older JDBC for 8.2, i will try updating
these components to more recent versions.

If the problem arises again i will hopefully be able to better
analyze, where the locking in my application occurs. It is in fact a
multi-threaded environment.

Best regards
Manuel


pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: perl and php connect problems to pgsql all of a sudden
Next
From: andreas@a-kretschmer.de
Date:
Subject: Re: maximum size limit for a query string?