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 MoreWorking Around the Missing xml Data Type in YugabyteDB
PostgreSQL includes a native xml data type and a rich set of XML/XPath functions (XMLEXISTS, xpath, xpath_exists, XMLSERIALIZE, XMLTABLE, etc.). YugabyteDB does […]
Read MoreAutomatically keeping table statistics up to date for better query plans
🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
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 MoreEfficient CIDR Range Lookups Using Expression Indexes
🚀 Introduction YugabyteDB fully supports PostgreSQL’s inet and cidr datatypes, allowing you to store and manipulate IPv4 and IPv6 network addresses. However, […]
Read More