In PostgreSQL-compatible databases like YugabyteDB, the system catalogs are packed with metadata about tables, functions, privileges, and more. But not all system […]
Read MoreHow to Index Encrypted Data in YugabyteDB Using SHA-256 Hashes
Storing sensitive information like Social Security Numbers (SSNs) securely is non-negotiable… but what happens when you need to search or index that […]
Read MoreList 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 More