postgres-internals

1 article
sort: new top best
clear filter
0 7/10

A deep dive into PostgreSQL memory management failures caused by work_mem misunderstandings: a single poorly-written query combining a plpgsql function with hash joins accumulated 2 TB of RAM because memory contexts are only released at query completion, not per-operation. The article explains root causes, introduces pg_log_backend_memory_contexts for debugging, and provides mitigation strategies including query rewrites and statement timeouts.

PostgreSQL pg_log_backend_memory_contexts Henrietta Dombrovskaya Nordic PGDay 2026 ExecutorState HashTableContext
mydbanotebook.org · giulianopz · 1 day ago · details · hn