[PERFORM] 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 and I come up with the
shared_buffersas 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?