Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection
Date
Msg-id 8343.1467943278@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14234: PostgreSQL consuming large amount of memory for persistent connection  (digoal@126.com)
Responses Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #14217: Respect $CFLAGS from /usr/local/etc/config.site
Next
From: andrew@tao11.riddles.org.uk
Date:
Subject: BUG #14235: inconsistencies with IS NULL / IS NOT NULL