Re: Postgre "idle" process using 100% CPU

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgre "idle" process using 100% CPU
Дата
Msg-id 24680.1118592081@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgre "idle" process using 100% CPU  (Jernej Kos <kostko@jweb-network.net>)
Ответы Re: Postgre "idle" process using 100% CPU  (Jernej Kos <kostko@jweb-network.net>)
Список pgsql-general
Jernej Kos <kostko@jweb-network.net> writes:
> Well there should be no complex queries executed (there are some huge tables,
> but the queries aren't huge or specially complicated). I tried attaching to
> the process via gdb and the process is executing method:

> HeapTupleSatisfiesSnapshot()

> The backtrace appears to be useless (too many ??s). Is that of any help ?

It's really hard to see how it could get to HeapTupleSatisfiesSnapshot()
without being inside a query --- too bad you can't get a more usable
backtrace.  Is it worth recompiling with --enable-debug to investigate
this?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Jernej Kos
Дата:
Сообщение: Re: Postgre "idle" process using 100% CPU
Следующее
От: "Darrell A. Sullivan, II"
Дата:
Сообщение: Use of Indexes