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.htmlhttp://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.