Paul Jones <admin@cmicdo.com> writes:
> I may have discovered a situation in 10.1 where EXECUTEing a PREPARED
> statement acting on JSON data in partitioned tables hangs in an
> infinite loop for a particular set of data. Unfortunately, the data is
> proprietary, so I did the best I could below to describe what happened.
You haven't provided any real reason to think that this represents an
infinite loop and not just a really slow query. The query's filter
conditions are complex enough to render the planner's estimates basically
works of fiction :-(, so I have no faith in the estimates suggesting that
only a relatively small number of rows will get processed. It's
definitely making some progress, because your successive backtraces
show different blocks getting read.
regards, tom lane
