Distributed SQL databases like YugabyteDB guarantee correctness across nodes, even when clocks drift, and sometimes that means YSQL will stop a query […]
Read More
List All Non‑Default GUC Settings
If you’ve ever changed session configuration parameters using SET …, it’s handy to know which settings differ from the defaults. YugabyteDB exposes […]
Read MoreUse EXPLAIN (SETTINGS) to See Which GUCs Shaped Your Query Plan
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 MoreResetting 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 More