Re: out of memory woes - Mailing list pgsql-general

From Angva
Subject Re: out of memory woes
Date
Msg-id 1166563696.532099.250200@80g2000cwy.googlegroups.com
Whole thread Raw
In response to out of memory woes  ("Angva" <angvaw@gmail.com>)
Responses Re: out of memory woes  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
We found that the kernel setting SHMALL was set ridiculously high -
1024g!. Someone noticed this when running "ipcs -lm" - seemed just a
tad off. :)

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1

Now it is set to ceil(SHMMAX/PAGE_SIZE) as recommended in the Postgres
documentation. Testing the heck out of the parallel clusters now...

Mark


pgsql-general by date:

Previous
From: "Angva"
Date:
Subject: Re: out of memory woes
Next
From: "Amit Mody"
Date:
Subject: windows - silent uninstall question