Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_locks concern - Mailing list pgsql-novice

From Ries van Twisk
Subject Re: pg_locks concern
Date
Msg-id 7FD265C1-1A94-4117-997A-79208F2C41D8@rvt.dds.nl
Whole thread Raw
In response to pg_locks concern  ("Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>)
List pgsql-novice
Tree view



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,

If you application sit's at 100% then it's not PG and you need to look there rather then looking into PostgreSQL.
It also helps if you tell is more about the application, what version of PostgreSQL you have
and what queries are running..







pgsql-novice by date:

Previous
From: "Ridvan Lakas ng Bayan S. Baluyos"
Date:
Subject: pg_locks concern
Next
From: Michael Wood
Date:
Subject: Possibly corrupted pg_control file after machine crash