Some Postgres settings are simple and straight forward, others can have big impact and be harder to know what the perfect setting is such as work_mem. This guide walks through how much memory you use in a sort, and helps you properly set a good work_mem value.
|