Does the work mem is used when I do sorts or hash operations on temp tables ? Or the temp_buffer that is allocated at the beginning of the session is used for it ?
At one of our apps, the app create a temp table and run on it some operations (joins,sum,count,avg ) and so on.. I saw in the postgresql.conf that fs temp files are generated so I guested that the memory buffer that was allocated for that session was too small. The question is should I increase the work_mem or the temp_buffers ?