Hi experts, For an academic experiment I need to *restrict the total amount of memory that is available for a pgSQL server* to compute a given set of queries.
I know that I can do this through postgressql.conffile, where I can adjust some parameters related with Resource Management. The problem is that: it's not clear for me--given the several parameters available on the config file--which is the parameter that I should change. When I first opened the config file I'm expecting someting like this: max_server_memmory. Instead I found a lot of: shared_buffers, temp_buffers, work_mem, and so on... Given that, I've consulted pgSQL docs. on Resource Consumption <http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html> and I come up with the shared_buffers as the best candidate for what I'm looking for: *the parameter that restricts the total amount of memory that a pgSQL server can use to perform its computation*. But I'm not completely sure about this. Can you guys give me some insight about which parameters should I adjust to restrict the pgSQL server's memory, please?