[EMAIL PROTECTED] wrote:
The Prozess Postmaster takes 99% of Cpu.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20726 postgres 17 0 19996 5356 4216 R 98.3 0.3 26:36.56 postmaster
19956 postgres 19 0 19996 6148 4936 R 64.4 0.3 28:38.38 postmaster
...
I have read all the Faq. But there is no reason to it.
Could you help?
Is it doing anything?
Do your logs show any activity?
If you do "strace -p <pid>" as root, you'll see what system calls the
backend is making.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
