Jernej Kos <kostko@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
