Re: SHMMAX problem - how much is needed? - Mailing list pgsql-admin

From Peter Koczan
Subject Re: SHMMAX problem - how much is needed?
Date
Msg-id 4544e0330711131308p62a78e84t4380df68d1624ef5@mail.gmail.com
Whole thread Raw
In response to SHMMAX problem - how much is needed?  (Laszlo Nagy <gandalf@shopzeus.com>)
Responses Re: SHMMAX problem - how much is needed?  (Laszlo Nagy <gandalf@shopzeus.com>)
List pgsql-admin
> Minimum shared mem:  140731400 bytes = 135.0 MB
> Maximum shared mem:  268435456 bytes = 256.0 MB
>
> kern.ipc.shmmin="140731400"
> kern.ipc.shmmax="268435456"
>
> Nov 13 20:46:19 neptunus postgres[669]: [1-2] DETAIL:  Failed system
> call was shmget(key=5432001, size=21725184, 03600).

The shared memory request, according to the error message, was for ~20
MB, far less than the 135 MB minimum limit you put in the kernel.
You'll need to lower the limit or raise your request size, probably
with regards to shared_buffers, as I think you're only allocating 2 MB
to shared_buffers. You'll want to raise that on a production machine.

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Escape string tracing
Next
From: Laszlo Nagy
Date:
Subject: Re: SHMMAX problem - how much is needed?