Re: Query error: could not resize shared memory segment

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Query error: could not resize shared memory segment
Дата
Msg-id CAEepm=2wXSfmS601nUVCftJKRPF=PRX+DYZxMeT8M2WwLSanVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query error: could not resize shared memory segment  (Thuc Nguyen Canh <thucnguyencanh@gmail.com>)
Ответы Re: Query error: could not resize shared memory segment  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Query error: could not resize shared memory segment  (Thuc Nguyen Canh <thucnguyencanh@gmail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Thuc Nguyen Canh
Дата:
Сообщение: Re: Query error: could not resize shared memory segment
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query error: could not resize shared memory segment