Re: Postgre "idle" process using 100% CPU

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 ?

Regards,
Jernej Kos.

On Thursday 09 of June 2005 17:19, you wrote:
> Jernej Kos <kostko(at)jweb-network(dot)net> writes:
> > i am using postgresql version 8.0.1 on Gentoo Linux and from time to time
> > a postgres process that is marked as idle - "postgres: user db IP(34079)
> > idle" - starts using 100% CPU. There is nothing in the logs, so i don't
> > have a clue what could be the problem.
>
> For a long time? I'd expect it to go busy on receiving a command
> somewhat before changing the PS status, because command parsing
> happens first (else it can't know what to set the status to ...).
> If you are in the habit of sending enormously complex SQL commands
> then maybe this state would last long enough to notice.
>
> If you don't think that's it, maybe you could attach to the busy
> backend with gdb and get a stack trace to find out what it's doing?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Jernej Kos <kostko(at)jweb-network(dot)net>
JWeb-Network