Re: pg_locks concern

ridvan@baluyos.net ("Ridvan Lakas ng Bayan S. Baluyos") writes:

> Hi list,
> I'm new in administering postgres database server. I would like to ask a question what's causing these locks and what
arethe consequences? 
> Currently, we have single application that consumes 100% CPU Utilization of our server.

Have you availed yourself of the fine documentation?

http://www.postgresql.org/docs/8.3/static/view-pg-locks.html
http://www.postgresql.org/docs/8.3/static/explicit-locking.html

This gives some decent detail as to what kinds of locks are acquired
and why, in general.
--
(format nil "~S@~S" "cbbrowne" "cbbrowne.com")
http://cbbrowne.com/info/multiplexor.html
There are few personal problems which can't be solved by the suitable
application of high explosives.