Unable to allocate 2G of shared memory on wheezy

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Unable to allocate 2G of shared memory on wheezy
Date: 2014-06-18 19:00:45
Message-ID: CADK3HH+iffaL7rJWvr49k0Ln917uPWnOszowox5Pv9OV5ZO66A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Here are my kernel settings

kernel.shmmax = 10737418240

# Maximum total size of all shared memory segments in pages (normally 4096
bytes)
kernel.shmall = 2621440
kernel.sem = 250 32000 32 1200

They are actually set...

sysctl -a | grep shm
kernel.shmmax = 10737418240
kernel.shmall = 2621440
kernel.shmmni = 4096

To reduce the request size [FAILently 2232950784 bytes), reduce
PostgreSQL's shared memory usage,

Dave Cramer

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2014-06-18 19:15:12 Re: Unable to allocate 2G of shared memory on wheezy
Previous Message Gezeala M. Bacuño II 2014-06-17 16:41:37 Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports