# Perguntas sobre db\_work\_mem

**URL:** <https://meta.discourse.org/t/questions-about-db-work-mem/189757>\
**Category:** Self-hosting\
**Created:** [Maio 8, 2021, 9:56am UTC](https://meta.discourse.org/t/questions-about-db-work-mem/189757 "2021-05-08T09:56:04Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Don](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/don/32/228726_2.png) [@Don](https://meta.discourse.org/u/Don)\
**Post date:** [Maio 8, 2021, 8:43pm UTC](https://meta.discourse.org/t/questions-about-db-work-mem/189757/5 "2021-05-08T20:43:47Z")

</div>

Encontrei [a fórmula aqui](https://www.enterprisedb.com/postgres-tutorials/how-tune-postgresql-memory) para calcular o `db_work_mem`.

Por padrão, ele está configurado para 100 conexões.

> RAM total \* 0,25 / max\_connections

Tenho **4096MB \* 0,25 / 100 = ~10MB**

No template `postgres.template.yml`, o valor padrão de `db_work_mem: "10MB"` é calculado com base nessa fórmula, creio eu. Acho que esses 10MB são o máximo atualmente. Obrigado, Jay 🙂

---

_[View the full topic](https://meta.discourse.org/t/questions-about-db-work-mem/189757)._