protecting some processes from out-of-swap killer

[Dmitry Morozovsky]

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!


-- 
Sincerely,
D.Marck                                     [DM5020, MCK-RIPE, DM3-RIPN]
[ FreeBSD committer:                                 marck at FreeBSD.org ]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck at rinet.ru ***
------------------------------------------------------------------------