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@xxxxxxxxxxxxxxxx> wrote: > On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh > <thucnguyencanh@xxxxxxxxx> 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
