Hubert (depesz) Lubaczewski • 5/5/2025

Waiting for PostgreSQL 18 – Add function to get memory context stats for processes

A new function in PostgreSQL 18 allows administrators to retrieve detailed memory context statistics from any backend or auxiliary process (like the WAL writer) for debugging under memory pressure. It works by signaling the target process to publish its stats to shared memory, with timeout handling and summary options, extending the existing pg_backend_memory_contexts view to all processes.

0 comments

#performance monitoring #memory management #postgresql