Re: is there a way to firmly cap postgres worker memory consumption?

Поиск
Список
Период
Сортировка
От Steve Kehlet
Тема Re: is there a way to firmly cap postgres worker memory consumption?
Дата
Msg-id CA+bfosE7P3ovfu9yPFUmHY-2-EYHy-tE3D2tn-xgoLa_1_Tk6A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: is there a way to firmly cap postgres worker memory consumption?  (Amador Alvarez <apradopg@gmail.com>)
Ответы Re: is there a way to firmly cap postgres worker memory consumption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Did you check if your OS allows you to limit memory usage per user / process basis?

I'll definitely dig more into this. I found some stuff saying it isn't as easy as one would expect, i.e. not just a ulimit and done. Or maybe it is, in this case. I will play around.
 
Did you either profiled or debugged it to see what is going on?

I would love to learn more about how to do this, to get to the bottom of the memory usage. I can google around, or can you suggest any reads?
 
When memory consumption grows , Doesn't ever swap out?

Yes, it consumes all swap.

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Increase in max_connections
Следующее
От: Tom Lane
Дата:
Сообщение: Re: is there a way to firmly cap postgres worker memory consumption?