Estimating work_mem

Nik and Michael are joined by Shaun Thomas to discuss estimating work_mem, memory management in general, and writing an extension to help.

Here are some links to things they mentioned:
• Shaun Thomas postgres.fm/people/shaun-thomas
• work_mem postgresql.org/docs/current/runtime-config-res…
• pg_stat_database postgresql.org/docs/current/monitoring-stats.h…
• ALTER ROLE SET configuration_parameter postgresql.org/docs/current/sql-alterrole.html…
• hash_mem_multiplier postgresql.org/docs/current/runtime-config-res…
• Recent Postgres releases with 28 CVEs fixed postgresql.org/about/news/postgresql-186-1711-…
• Systemic Risks in the Managed PostgreSQL Industry (part 1 of 6, Mehmet Ince) mehmetince.net/part-1-6-systemic-risks-in-the-…
• Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) techcommunity.microsoft.com/blog/adforpostgres…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork