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 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?