Re: Query error: could not resize shared memory segment - Mailing list pgsql-general

From Thuc Nguyen Canh
Subject Re: Query error: could not resize shared memory segment
Date
Msg-id CAG903PpRcP7SgW1H72GF5Ukjd9E_8amsUX2YpKCNQNCvD=_O2g@mail.gmail.com
Whole thread Raw
In response to Re: Query error: could not resize shared memory segment  (Thomas Munro <thomas.munro@enterprisedb.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query error: could not resize shared memory segment
Next
From: Igal Sapir
Date:
Subject: Re: Returning Values from INSERT ON CONFLICT DO NOTHING