Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1

Поиск
Список
Период
Сортировка
От Tarabas
Тема Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1
Дата
Msg-id 1854590392.20110607175013@tarabas.de
обсуждение исходный текст
Ответ на Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: [bulk] Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1  (Tarabas <tarabas@tarabas.de>)
Список 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 по дате отправления:

Предыдущее
От: Condor
Дата:
Сообщение: Re: perl and php connect problems to pgsql all of a sudden
Следующее
От: andreas@a-kretschmer.de
Дата:
Сообщение: Re: maximum size limit for a query string?