Re: Out of Memory - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Out of Memory
Date
Msg-id a76a969d353eacf584d2018b3a2272a1143053e9.camel@cybertec.at
Whole thread Raw
In response to Re: Out of Memory  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Out of Memory  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Rob Sargent wrote:
> > Christoph Moench-Tegeder wrote:
> > > ## Laurenz Albe (laurenz.albe@cybertec.at):
> > > 
> > > > vm.overcommit_memory = 2
> > > > vm_overcommit_ratio = 100
> > > > 
> > > > Linux commits (swap * overcommit_ratio * RAM / 100),
> > > 
> > >                      ^
> > >                      That should be a "+".
> > 
> > Yes; shame on me for careless typing, and thank you for the
> > correction.
> 
> Are there any parentheses needed in that formula?

No.  It is swap space plus a certain percentage of RAM.

I don't know how the Linux developers came up with that
weird formula.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: How to maintain the csv log files in pg_log directory only for past30 days
Next
From: Michael Paquier
Date:
Subject: Re: How to maintain the csv log files in pg_log directory only forpast 30 days