Intro To export schema from YugabyteDB, the most common approach is to use the ysql_dump utility: ysql_dump –include-yb-metadata This produces DDL that […]
Read MoreHow to Replace ST_SetSRID(ST_MakePoint(…),4326) from PostgreSQL/PostGIS in YugabyteDB (Without PostGIS)
Inroduction Many PostgreSQL applications that use PostGIS construct geographic points like this: ST_SetSRID(ST_MakePoint(lon, lat), 4326) This pattern is extremely common in location-based […]
Read MoreDesigning the Best Index for a Query in YugabyteDB
Across this indexing series, we improved the same query step by step. We started with a simple index on tenant_id. Then we: […]
Read MoreHow Covering Indexes Can Eliminate Table Reads in YugabyteDB
In the YugabyteDB Tip, How ORDER BY LIMIT Can Change the Best Index in YugabyteDB, the fitth tip in our index tuning […]
Read More