Re: BUG #16302: too many range table entries - when count partition table(65538 childs)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16302: too many range table entries - when count partition table(65538 childs)
Дата
Msg-id 32763.1584198185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16302: too many range table entries - when count partition table(65538 childs)  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16302: too many range table entries - when count partitiontable(65538 childs)  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
>   when i count a partition table with many childs , it's error below:

> postgres=> select count(*) from p;
> ERROR:  54000: too many range table entries
> LOCATION:  add_rte_to_flat_rtable, setrefs.c:425

This hardly seems like a bug.  We do not support an infinite number of
partitions --- and in the real world, performance would have tanked
long before you got to this many partitions.

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16302: too many range table entries - when count partition table(65538 childs)
Следующее
От: Daniel WM
Дата:
Сообщение: Re: BUG #16293: postgres segfaults and returns SQLSTATE 08006