Jeison Bedoya <jeisonb@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
