A nice guide on how and when to tweak Postgres work_mem configuration variable

All about understanding and using the work_mem setting in PostgreSQL, so you can tune how much memory can be used by various Postgres database activities. With a flyby on how Citus intelligently tunes the work_mem setting in our managed database service.