Re: Error reporting when hitting shared memory limits -

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Pete Leonard <pete(at)hero(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Error reporting when hitting shared memory limits -
Date: 2001-08-25 14:18:11
Message-ID: 4245.998749091@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konstantinos Agouros 2001-08-25 14:32:23 Re: Stupid foreign key question
Previous Message Konstantinos Agouros 2001-08-25 14:11:22 Stupid foreign key question