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
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 |