TL;DR A previous YugabyteDB tip, Measure Total Postgres Backend Usage, showed how to measure total current backend memory usage using PSS (Proportional […]
Read More
Tuning 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 MoreRetain Hot or Warm Data in Memory to Enhance Read Performance
In PostgreSQL, shared_buffers is a configuration parameter that determines the amount of memory dedicated to caching data blocks in shared memory. This is […]
Read More