On Jul 13, 2015, at 6:49 PM, Ryan King - NOAA Affiliate <ryan.king@xxxxxxxx> 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@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
