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
Measure 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