When troubleshooting query behavior, connection sizing, or general node health, it can be useful to answer a few simple questions: ● How […]
Read More
Use VmHWM to Catch “Memory-Heavy” YSQL Backends (and Help Prevent OOMs)
TL;DR A previous YugabyteDB tip, Measure Total Postgres Backend Usage, showed how to measure total current backend memory usage using PSS (Proportional […]
Read MoreTuning work_mem in YugabyteDB
When it comes to query performance in PostgreSQL-compatible databases like YugabyteDB, one of the most impactful (and often overlooked) settings is work_mem. […]
Read MoreMeasure Total Postgres Backend Usage
In YugabyteDB, a PostgreSQL backend process refers to the individual processes that manage SQL client connections in a PostgreSQL-compatible way. Built on […]
Read More