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 MoreHow ORDER BY LIMIT Can Change the Best Index in YugabyteDB
In Tip #3, we improved our index so filtering happened inside the index scan. In Tip #4, we saw how IN() predicates […]
Read More