Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection
Дата
Msg-id 8343.1467943278@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14234: PostgreSQL consuming large amount of memory for persistent connection  (digoal@126.com)
Ответы Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection  (德哥 <digoal@126.com>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #14217: Respect $CFLAGS from /usr/local/etc/config.site
Следующее
От: andrew@tao11.riddles.org.uk
Дата:
Сообщение: BUG #14235: inconsistencies with IS NULL / IS NOT NULL