Re: pg_locks concern

Поиск
Список
Период
Сортировка
От Ries van Twisk
Тема Re: pg_locks concern
Дата
Msg-id 7FD265C1-1A94-4117-997A-79208F2C41D8@rvt.dds.nl
обсуждение исходный текст
Ответ на pg_locks concern  ("Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>)
Список 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,

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 по дате отправления:

Предыдущее
От: "Ridvan Lakas ng Bayan S. Baluyos"
Дата:
Сообщение: pg_locks concern
Следующее
От: Michael Wood
Дата:
Сообщение: Possibly corrupted pg_control file after machine crash