Re: ERROR: out of memory DETAIL: Failed on request of size ??? - Mailing list pgsql-general

From Tomas Vondra
Subject Re: ERROR: out of memory DETAIL: Failed on request of size ???
Date
Msg-id 1e2e6b63947528f693dc54d38a2d0ca9.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: ERROR: out of memory DETAIL: Failed on request of size ???  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Hi,

On 22 Listopad 2013, 20:09, Edson Richter wrote:
>
> Excuse me (or just ignore me) if it is a stupid question, but have you
> configured sysctl.conf accordingly?
> For instance, to use larget memory settings, I had to configure my EL as
> follows:
>
> # Controls the maximum shared segment size, in bytes
> kernel.shmmax = 68719476736
>
> # Controls the maximum number of shared memory segments, in pages
> kernel.shmall = 4294967296

This only influences shared memory, which is used for shared buffers (not
for memory allocated during query execution, as that's translated to plain
malloc). With sysctl.conf misconfigured, the database would not start at
all and you'd get a reasonable error message in the log, suggesting pretty
clearly where/how to fix it.

Tomas



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: "shared_buffers" and "temp_buffers" why manual and code are different?
Next
From: Vik Fearing
Date:
Subject: Re: Getting non_NULL right-side values on a non-matching join?