Postgres Pro
Downloads
Home   >   mailing lists

Unable to allocate 2G of shared memory on wheezy - Mailing list pgsql-performance

From Dave Cramer
Subject Unable to allocate 2G of shared memory on wheezy
Date
Msg-id CADK3HH+iffaL7rJWvr49k0Ln917uPWnOszowox5Pv9OV5ZO66A@mail.gmail.com
Whole thread Raw
Responses Re: Unable to allocate 2G of shared memory on wheezy
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Gezeala M. Bacuño II
Date:
Subject: Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports
Next
From: Tom Lane
Date:
Subject: Re: Unable to allocate 2G of shared memory on wheezy