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

On Sun, Mar 15, 2020 at 12:03 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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.

Would it make sense to document this hard upper bound on the number of
relations that can be handled by a query?

--
Thank you,
Amit