Baptiste Daroussin
2015-Apr-25 10:43 UTC
protecting some processes from out-of-swap killer
On Sat, Apr 25, 2015 at 01:31:14PM +0300, Dmitry Morozovsky wrote:> Hi there colleagues, > > I have stable/10 on a rather big machine (2*8*2 e5 Xeon, 64G RAM, SAS+SSD ZFS > raid10+ZIL+L2ARC) acting as a PostgreSQL server. > > To use such a big resource pool that is mostly idle, I'd deployed poudriere > there (using tmpfs) too. > > Most times this combination works like a charm: LA could be 60+ and no visual > latency increase on SQL queries. > > However, sometimes postgres processes got killed by 'out of swap space'. > I suppose the source of problem could be that VSZ size of postgres processes > (8-9 G) is bigger than swap congigured (4G). > > Is there any way to prevent this, besides reallocating space for swap? > > Quick googling does not help, at least I could not find answers relevant > enough. > > Thanks!protect(1) ? Best regards, Bapt -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 181 bytes Desc: not available URL: <http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20150425/543070e3/attachment.sig>
On Sat, 25 Apr 2015, Baptiste Daroussin wrote:> > However, sometimes postgres processes got killed by 'out of swap space'. > > I suppose the source of problem could be that VSZ size of postgres processes > > (8-9 G) is bigger than swap congigured (4G). > > > > Is there any way to prevent this, besides reallocating space for swap? > > protect(1) ?Of course. I really do not understand how google hides the man page from me. Thanks, and sorry fot the noise. -- Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] [ FreeBSD committer: marck at FreeBSD.org ] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck at rinet.ru *** ------------------------------------------------------------------------
On Sat, Apr 25, 2015, at 05:43, Baptiste Daroussin wrote:> On Sat, Apr 25, 2015 at 01:31:14PM +0300, Dmitry Morozovsky wrote: > > Hi there colleagues, > > > > I have stable/10 on a rather big machine (2*8*2 e5 Xeon, 64G RAM, SAS+SSD ZFS > > raid10+ZIL+L2ARC) acting as a PostgreSQL server. > > > > To use such a big resource pool that is mostly idle, I'd deployed poudriere > > there (using tmpfs) too. > > > > Most times this combination works like a charm: LA could be 60+ and no visual > > latency increase on SQL queries. > > > > However, sometimes postgres processes got killed by 'out of swap space'. > > I suppose the source of problem could be that VSZ size of postgres processes > > (8-9 G) is bigger than swap congigured (4G). > > > > Is there any way to prevent this, besides reallocating space for swap? > > > > Quick googling does not help, at least I could not find answers relevant > > enough. > > > > Thanks! > > protect(1) ? >Thanks for asking, Dmitry, as I've now learned of a new useful command. It appears it has only been around a short time:> Added Thu Sep 19 18:53:42 2013 UTC (19 months, 1 week ago) by jhbVery cool. :-)