Re: SHMMAX problem - how much is needed?

From: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
To: "Laszlo Nagy" <gandalf(at)shopzeus(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SHMMAX problem - how much is needed?
Date: 2007-11-13 21:08:28
Message-ID: 4544e0330711131308p62a78e84t4380df68d1624ef5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laszlo Nagy 2007-11-13 21:20:18 Re: SHMMAX problem - how much is needed?
Previous Message Laszlo Nagy 2007-11-13 20:57:51 Re: SHMMAX problem - how much is needed?