Re: Error reporting when hitting shared memory limits - - Mailing list pgsql-general

From Tom Lane
Subject Re: Error reporting when hitting shared memory limits -
Date
Msg-id 4245.998749091@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error reporting when hitting shared memory limits -  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> The FreeBSD shmget(2) man page does not document this error (ENOMEM).
> However, the Linux shmget(2) page says

>        ENOMEM      is returned if no memory  could  be  allocated
>                    for segment overhead.

> which probably means to raise SHMALL.

FWIW, HPUX 10.20 sez

          [ENOMEM]       A shared memory identifier and associated shared
                         memory segment are to be created, but the amount
                         of available physical memory is not sufficient to
                         fill the request.

which implies that you've got to buy more RAM.  But experimentation
indicates that the error is actually delivered only if your request
would overrun available swap space, not physical RAM.  AFAICT this
system does not even have a SHMALL parameter, though it does have a
SHMMAX limit on the size of any one shmem segment.

            regards, tom lane

pgsql-general by date:

Previous
From: elwood@agouros.de (Konstantinos Agouros)
Date:
Subject: Stupid foreign key question
Next
From: elwood@agouros.de (Konstantinos Agouros)
Date:
Subject: Re: Stupid foreign key question