Re: Postgre "idle" process using 100% CPU

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jernej Kos <kostko(at)jweb-network(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgre "idle" process using 100% CPU
Date: 2005-06-12 16:01:21
Message-ID: 24680.1118592081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jernej Kos <kostko(at)jweb-network(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2005-06-12 18:28:35 Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
Previous Message Jernej Kos 2005-06-12 15:53:41 Re: Postgre "idle" process using 100% CPU