> `work_mem` is the amount of memory a connection has to, you know, do work. It's the amount of memory a connection has to do work per sorting/hashing operatio

> `work_mem` is the amount of memory a connection has to, you know, do work. It's the amount of memory a connection has to do work per sorting/hashing operation. https://www.postgresql.org/docs/12/runtime-config-resource.html https://www.postgresql.org/docs/12/runtime-config-resource.h... > There's no way for example to say: I want all the connections from username "myapp" to have 10MB and those from user "reporting" to have 100MB. Yes, you can with `ALTER ROLE myapp SET work_mem TO '10mb';` and `ALTER ROLE reporting SET work_mem TO '100mb';