Re: The memory usage is positively correlated with the number of partition tables when pg_get_expr is called. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: The memory usage is positively correlated with the number of partition tables when pg_get_expr is called.
Date
Msg-id 989438.1755691750@sss.pgh.pa.us
Whole thread Raw
In response to The memory usage is positively correlated with the number of partition tables when pg_get_expr is called.  (Zhu Yang <fairyfar@msn.com>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Kirill Reshke
Date:
Subject: Re: BUG #19026: ResourceOwnerForget can't find owner for invalid plancache
Next
From: Dilip Kumar
Date:
Subject: Re: BUG #19026: ResourceOwnerForget can't find owner for invalid plancache