The surprising logic of the Postgres work_mem setting, and how to tune it

*Find the article on our blog here:*

In E119 of "5mins of Postgres" we discuss tuning the Postgres work_mem setting for your workload, and why it can be quite confusing to interpret the meaning of work_mem correctly for a given query. We also discuss the impact of hash_mem_multiplier, and why it's default changed from 1.0 to 2.0 in Postgres 15.

*Learn more about pganalyze:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*How to Get the Most out of Postgres Memory Settings - Blog post by Shaun Thomas on the Tembo blog*

*Linux Memory Overcommit - Postgres documentation*

*"Postgresql OOM" - Mailinglist response by Andres Freund on pgsql-hackers mailinglist*

*hash_mem_multiplier setting - Postgres documentation*

*"Time to increase hash_mem_multiplier default?" - Mailinglist thread by Peter Geoghegan on pgsql-hackers mailinglist*

*Everything you know about setting `work_mem` is wrong - Blog post by Christophe Pettus*

#postgres #postgresql #queryoptimization