pg_locks concern - Mailing list pgsql-novice

From Ridvan Lakas ng Bayan S. Baluyos
Subject pg_locks concern
Date
Msg-id 7f4f9efa0907021931u7fc914baob227ed75881dad90@mail.gmail.com
Whole thread Raw
Responses Re: pg_locks concern  (Ries van Twisk <pg@rvt.dds.nl>)
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: UUID functions - installation
Next
From: Ries van Twisk
Date:
Subject: Re: pg_locks concern