The surprising logic of the Postgres work_mem setting, and how to tune it
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
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:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 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
https://tembo.io/blog/optimizing-memo...
Linux Memory Overcommit - Postgres documentation
https://www.postgresql.org/docs/curre...
"Postgresql OOM" - Mailinglist response by Andres Freund on pgsql-hackers mailinglist
https://www.postgresql.org/message-id...
hash_mem_multiplier setting - Postgres documentation
https://www.postgresql.org/docs/16/ru...
"Time to increase hash_mem_multiplier default?" - Mailinglist thread by Peter Geoghegan on pgsql-hackers mailinglist
https://www.postgresql.org/message-id...
Everything you know about setting `work_mem` is wrong - Blog post by Christophe Pettus
https://thebuild.com/blog/2023/03/13/...
#postgres #postgresql #queryoptimization