On Tue, May 17, 2016 at 12:11 AM, Lucas Possamai <drum.lu...@gmail.com> wrote: > This is my postgresql.conf at the moment: > > shared_buffer(51605MB) + > effective_cache_size(96760MB) + > work_mem(32MB) + > max_connections(200) > > = 148397.08 MB
You are comparing some very dissimilar settings. effective_cache_size does not allocate memory, it tells the planner how much cache you have allocated (i.e., the sum of shared_buffers and the OS cache). work_mem can be allocated zero to a large number of times per active query. Every open connection will use some RAM, but the amount is hard to predict exactly. You might want to go over this page: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server ... and then read the documentation of any setting you are thinking of adjusting. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
