digoal@126.com writes:
> why PostgreSQL session do not release these memory?
> it will comsume these memory until disconnect.
Your session has created and accessed 100000 tables plus 100000 views.
I do not think you should complain if that takes a great deal of memory.
Either rethink why you need so many tables, or buy hardware commensurate
with the size of your problem.
regards, tom lane