When working with ysqlsh, the command history feature is extremely useful. It allows you to quickly recall previous queries using the up-arrow […]
Read More
How to Replace ST_DWithin Radius Queries in YugabyteDB Without PostGIS
Many geospatial applications built on PostgreSQL use PostGIS queries that combine: ● ST_DWithin() to filter objects within a radius ● bounding-box checks […]
Read MoreUnderstanding YSQL Catalog Caching in YugabyteDB
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 More