| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Out of Memory |
| Date: | 2018-09-28 05:23:59 |
| Message-ID: | a76a969d353eacf584d2018b3a2272a1143053e9.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Rob Sargent wrote:
> > Christoph Moench-Tegeder wrote:
> > > ## Laurenz Albe (laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2018-09-28 05:25:39 | Re: How to maintain the csv log files in pg_log directory only for past 30 days |
| Previous Message | Raghavendra Rao J S V | 2018-09-28 05:03:30 | How to maintain the csv log files in pg_log directory only for past 30 days |