Обсуждение: pg_locks concern

Hi list,

I'm new in administering postgres database server. I would like to ask a question what's causing these locks and what are the consequences?

Currently, we have single application that consumes 100% CPU Utilization of our server.

Here's the specs of our server,

• HPDL580
• Quad Quad (16 Logical Processors)
• 24GB Memory
• 4TB Storage

TIA,

RIdvan


--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

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.