Re: Query error: could not resize shared memory segment

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Thuc Nguyen Canh <thucnguyencanh(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query error: could not resize shared memory segment
Date: 2018-01-03 05:16:22
Message-ID: CAEepm=2wXSfmS601nUVCftJKRPF=PRX+DYZxMeT8M2WwLSanVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh
<thucnguyencanh(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-01-03 05:34:04 Re: Query error: could not resize shared memory segment
Previous Message Thuc Nguyen Canh 2018-01-03 05:13:51 Re: Query error: could not resize shared memory segment