Search Postgresql Archives

Re: Query error: could not resize shared memory segment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

If this is a common setup, maybe we're going to need a new section
under or near

https://www.postgresql.org/docs/current/static/kernel-resources.html#SYSVIPC

It's pretty annoying to have sweated blood to get out from under the
kernel's chosen-at-random SysV IPC limits, only to run into container
tmpfs limits that seem equally chosen with the aid of a dartboard.

			regards, tom lane




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux