Re: Query error: could not resize shared memory segment

Поиск
Список
Период
Сортировка
От Thuc Nguyen Canh
Тема Re: Query error: could not resize shared memory segment
Дата
Msg-id CAG903PpRcP7SgW1H72GF5Ukjd9E_8amsUX2YpKCNQNCvD=_O2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query error: could not resize shared memory segment  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-general
Thank you Thomas,

I make it work with extra setting --shm-size=1g in my docker run script.

On Wed, Jan 3, 2018 at 12:16 PM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh
> <thucnguyencanh@gmail.com> wrote:
>> And here is the result from postgres container:
>>
>> mount | grep /dev/shm
>> => shm on /dev/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=65536k)
>
> Bingo.  Somehow your container tech is limiting shared memory.  That
> error is working as designed.  You could figure out how to fix the
> mount options, or you could disable parallelism with
> max_parallel_workers_per_gather = 0.
>
> --
> Thomas Munro
> http://www.enterprisedb.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query error: could not resize shared memory segment
Следующее
От: Igal Sapir
Дата:
Сообщение: Re: Returning Values from INSERT ON CONFLICT DO NOTHING