Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group