Re: Error reporting when hitting shared memory limits -

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Error reporting when hitting shared memory limits -
Дата
Msg-id 4245.998749091@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Error reporting when hitting shared memory limits -  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: elwood@agouros.de (Konstantinos Agouros)
Дата:
Сообщение: Stupid foreign key question
Следующее
От: elwood@agouros.de (Konstantinos Agouros)
Дата:
Сообщение: Re: Stupid foreign key question