Distributed databases change the cost model of metadata access. In PostgreSQL, system catalog tables live locally on disk and are typically cached […]
Read MoreIdentifying YSQL Catalog Tables to Preload – Without Grepping Logs Across Nodes
When a new YSQL backend session executes a query for the first time, PostgreSQL must read metadata from system catalog tables In […]
Read MoreRight-Sizing Connections in YugabyteDB with YSQL Connection Manager (YCM)
Why Connection Counts Matter in YugabyteDB One of the most common questions when deploying YugabyteDB in production is: How many database connections […]
Read MoreHandling Variable-Length IN (…) Clauses with pg_hint_plan in YugabyteDB
Sometimes you need to force a specific query plan, even when the query includes an IN (…) list whose length changes at […]
Read More