Re: is there a way to firmly cap postgres worker memory consumption? - Mailing list pgsql-general

From Steve Kehlet
Subject Re: is there a way to firmly cap postgres worker memory consumption?
Date
Msg-id CA+bfosE7P3ovfu9yPFUmHY-2-EYHy-tE3D2tn-xgoLa_1_Tk6A@mail.gmail.com
Whole thread Raw
In response to Re: is there a way to firmly cap postgres worker memory consumption?  (Amador Alvarez <apradopg@gmail.com>)
Responses Re: is there a way to firmly cap postgres worker memory consumption?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Increase in max_connections
Next
From: Tom Lane
Date:
Subject: Re: is there a way to firmly cap postgres worker memory consumption?