Re: [GENERAL] Non-deterministic 100% CPU hang on postgres 9.3

2014-04-20 Thread Fenn Bailey
advance, Fenn. On Wed, Apr 16, 2014 at 2:25 PM, Fenn Bailey wrote: > Some more information on this: > >> >> > I say "hang", where really I've given up after ~12 hours execution. The >> > exact same query can then be terminated and run in <90 seconds, w

Re: [GENERAL] Non-deterministic 100% CPU hang on postgres 9.3

2014-04-15 Thread Fenn Bailey
Some more information on this: > > > I say "hang", where really I've given up after ~12 hours execution. The > > exact same query can then be terminated and run in <90 seconds, with none > > of the underlying data changing. > > But does the plan change? > > As it turns out it does. Some further ex

[GENERAL] Non-deterministic 100% CPU hang on postgres 9.3

2014-04-14 Thread Fenn Bailey
Hi all, I'm experiencing an issue where certain queries appear to non-deterministically "hang", with a CPU pinned at 100%. I say "hang", where really I've given up after ~12 hours execution. The exact same query can then be terminated and run in <90 seconds, with none of the underlying data chang