Re: could not create shared memory segment: Invalid argument

On Jul 13, 2015, at 6:49 PM, Ryan King - NOAA Affiliate <ryan(dot)king(at)noaa(dot)gov> wrote:
>
> Yeah thanks I see I was going the wrong way...thanks.
> So shared_buffers is 15gb and max_conn = 1000.

OK, you haven't shared your OS or hardware setup, but a few general points:

- 15GB is large for PG shared buffers; it usually doesn't help to go that high; remember, shared buffers is a kind of working cache, not the whole cache, PG depends on the OS caching of recently-used files;

- Your shmall is only 16GB. PG may not be the only user of shared memory. It doesn't make sense to have shmall * page size < shmmax.

- Also, does your platform have some absolute upper limit on shmmax? 250GB seems awfully high...

- With 1,000 clients, you'd likely benefit from connection pooling; after you get things up, you should consider pgbouncer.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice