Jeison Bedoya <jeisonb@audifarma.com.co> wrote:
> Ram: 128GB
> max_connections = 900
> temp_buffers = 128MB
Besides the concerns already expressed about work_mem, temp_buffers
could be a big problem. If a connection uses temp tables it
acquires up to 128MB, *and holds on it reserved for caching temp
tables for that connection for as long as the connection lasts*.
So, for 900 connections, that could be 112.5 GB. I would expect to
see performance decrease and eventually completely tank as more
connections reserved memory for this purpose.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company