đź“ť Introduction YugabyteDB’s cost-based optimizer (CBO) is designed to pick the lowest-cost execution plan. When using duplicate covering geo-localized indexes, this usually […]
Read More
Audit Table Stats & Last ANALYZE in YSQL
Ever see a query plan that suddenly flips to a seq scan, or cardinality estimates that are off by 100Ă—? Nine times […]
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 MoreSmarter Data Placement with Tablespaces and Wildcards
YugabyteDB has long supported PostgreSQL-compatible tablespaces to help control where data lives in a distributed cluster. This is especially useful when you […]
Read More