Memory | Postgres.FM 050 |

Nikolay and Michael discuss memory in PostgreSQL — how it works, important settings, and how to go about tuning them.

Here are links to a few things we mentioned:

* Resource Consumption (PostgreSQL docs) https://www.postgresql.org/docs/curre...
* Andres Freud tweet about shared_buffers   / 1438912583554113537  
* Henrietta (Hettie) Dombrovskaya https://hdombrovskaya.wordpress.com/a...
* annotated.conf (by ash Berkus) https://github.com/jberkus/annotated....
* Our episode about checkpoint tuning https://postgres.fm/episodes/wal-and-...
* Our episode about BUFFERS https://postgres.fm/episodes/buffers-...
* Analyzing the Limits of Connection Scalability in Postgres (blog post by Andres Freund) https://techcommunity.microsoft.com/t...
* Tuning memory parameters for Aurora PostgreSQL https://docs.aws.amazon.com/AmazonRDS...
* RDS for PostgreSQL memory https://docs.aws.amazon.com/AmazonRDS...
* EDB guide by Via Fearing https://www.enterprisedb.com/postgres...
* pg_stat_kcache https://github.com/powa-team/pg_stat_...
* pg_buffercache https://www.postgresql.org/docs/curre...
* Process and Memory Architecture chapter (from Hironobu SUZUKI) https://www.interdb.jp/pg/pgsql02.html
* PostgreSQL 14 internals PDF book from Egor Rogov (pages 37, 184) https://edu.postgrespro.com/postgresq...
* src/backend/storage/buffer/README https://github.com/postgres/postgres/...
* pg_backend_memory_contexts (PostgreSQL 14+) https://www.postgresql.org/docs/curre...
* pg_stat_io (coming in PostgreSQL 16) https://www.postgresql.org/docs/devel...
* pg_prewarm https://www.postgresql.org/docs/curre...
* Configuring work_mem blog post https://www.pgmustard.com/blog/work-mem

~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard


~~~


This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.