Re: Postgre "idle" process using 100% CPU

Jernej Kos <kostko@jweb-network.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