Re: The memory usage is positively correlated with the number of partition tables when pg_get_expr is called.

Zhu Yang <fairyfar@msn.com> writes:
> Unreasonable memory usage.

Not at all.  You have a session that has accessed 100000 tables.
If you don't want to eat a lot of relcache space, rethink your
schema.  (IMV, a table with hundreds or thousands of partitions
is an anti-pattern.)

            regards, tom lane