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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Possible hang in 10.1 with JSON query over partially indexed partitions
Дата
Msg-id 7994.1516324038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Possible hang in 10.1 with JSON query over partially indexedpartitions  (Paul Jones <admin@cmicdo.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Seamus Abshere
Дата:
Сообщение: warning for subquery that references a table but not its columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: warning for subquery that references a table but not its columns