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