Distributed SQL databases like YugabyteDB guarantee correctness across nodes, even when clocks drift, and sometimes that means YSQL will stop a query […]
Read More
Stop & Start YugabyteDB Aeon Nodes from Bash
What is YugabyteDB Aeon YugabyteDB, the distributed, PostgreSQL-compatible database, underlies YugabyteDB Aeon: a fully-managed, cloud-native “Database-as-a-Service” (DBaaS). Aeon lets you run clusters […]
Read MoreFast (and Slow) Ways to Insert Lots of Rows in YSQL
When inserting a large volume of rows into a YSQL table, the performance you get depends heavily on the SQL pattern you […]
Read MoreXML in, JSONB out: Best-Effort XML → JSONB in YugabyteDB YSQL
Most modern apps want to store semi-structured data as JSON/JSONB, but a lot of legacy or external systems still speak XML. YugabyteDB […]
Read MoreWhen the CBO Doesn’t Choose a Local Covering Index (And How to Work Around It)
📝 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