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
