Re: Possible hang in 10.1 with JSON query over partially indexed partitions

2018-01-18 Thread Tom Lane
Paul Jones 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 hap

Possible hang in 10.1 with JSON query over partially indexed partitions

2018-01-18 Thread Paul Jones
Version 10.1, Community version from PGDG repo OSRHEL 7.3 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 th

Possible hang in 10.1 with JSON query over partially indexed partitions

2018-01-17 Thread Paul Jones
Version 10.1, Community version from PGDG repo OS RHEL 7.3 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