Re: SHMMAX problem - how much is needed?

Поиск
Список
Период
Сортировка
От Peter Koczan
Тема Re: SHMMAX problem - how much is needed?
Дата
Msg-id 4544e0330711131308p62a78e84t4380df68d1624ef5@mail.gmail.com
обсуждение исходный текст
Ответ на SHMMAX problem - how much is needed?  (Laszlo Nagy <gandalf@shopzeus.com>)
Ответы Re: SHMMAX problem - how much is needed?  (Laszlo Nagy <gandalf@shopzeus.com>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Milen A. Radev"
Дата:
Сообщение: Re: Escape string tracing
Следующее
От: Laszlo Nagy
Дата:
Сообщение: Re: SHMMAX problem - how much is needed?