From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postmaster taking 100% of the CPU |
Date: | 2009-10-26 17:30:42 |
Message-ID: | 20091026173041.GA80101@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Postmaster's been spinning at 99/100% for a few hours.
trying to get an idea what would have caused it.
I'm on PG 8.3.5 linux.
Here's the gdb output (I'm not really all that gdb savvy, so if something else would let me know)
0x08281959 in textin ()
(gdb) bt
#0 0x08281959 in textin ()
#1 0x082c3d9f in InputFunctionCall ()
#2 0x081755dd in ?? ()
#3 0x081755dd in ?? ()
#4 0x08174fd3 in ExecEvalExprSwitchContext ()
#5 0x081890cd in ExecSubPlan ()
#6 0x08174ae1 in ?? ()
#7 0x08175040 in ExecQual ()
#8 0x0818322c in ExecHashJoin ()
#9 0x08174680 in ExecProcNode ()
#10 0x08185f1d in ExecNestLoop ()
#11 0x081746b0 in ExecProcNode ()
#12 0x0817ebbb in ExecAppend ()
#13 0x081745c0 in ExecProcNode ()
#14 0x081873b1 in ExecSort ()
#15 0x08174650 in ExecProcNode ()
#16 0x081875a6 in ExecUnique ()
#17 0x08174560 in ExecProcNode ()
#18 0x081873b1 in ExecSort ()
#19 0x08174650 in ExecProcNode ()
#20 0x081724c3 in ExecutorRun ()
#21 0x082133e3 in ?? ()
#22 0x082147a9 in PortalRun ()
#23 0x082111f1 in PostgresMain ()
#24 0x081e363d in ?? ()
#25 0x081e464f in PostmasterMain ()
#26 0x08198906 in main ()
Thanks
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Landscheidt | 2009-10-26 17:58:58 | How to list user-specific configuration parameters? |
Previous Message | David Wall | 2009-10-26 16:46:45 | Operational performance: one big table versus many smaller tables |