As of YugabyteDB 2025.1, you can now use the PostgreSQL feature EXPLAIN (SETTINGS) to see which planner-related GUCs (configuration settings) were non-default […]
Read More
Resetting the YSQL Session: Understanding RESET ALL in YugabyteDB
If you’ve ever found yourself deep in a performance tuning or debugging session in YugabyteDB, experimenting with session-level configuration parameters (also known […]
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 MoreSet a GUC (Grand Unified Configuration) Parameter to its Default Value
In YugabyteDB, GUC stands for Grand Unified Configuration. These are configuration parameters that control various aspects of the database system, such as […]
Read More