When troubleshooting YSQL memory, there are really three different questions: 1. How much memory is being used?2. Which YSQL backend is consuming […]
Read More
Check Session and Server Memory from ysqlsh
When troubleshooting query behavior, connection sizing, or general node health, it can be useful to answer a few simple questions: ● How […]
Read MoreUse 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 More