https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server

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?