Version scope: This tip applies specifically to YugabyteDB v2024.2 and earlier. The YSQL API in these releases is based on PostgreSQL 11, […]
Read More
ybhnsw Can Index Wider Vectors Than PostgreSQL pgvector HNSW
When working with vector search, dimension limits matter. Many embedding models fit comfortably inside 768, 1,024, or 1,536 dimensions. But some use […]
Read MoreThe LIMIT Trap: Don’t Rely on Implicit Row Ordering in YugabyteDB
A new index can make a query faster. It can also change which rows come back first. That matters a lot when […]
Read MoreUse pg_stats to Spot Low-Cardinality Index Hotspots Before They Spot You
When migrating from PostgreSQL to YugabyteDB, table load time is only part of the story. Secondary indexes can become the real bottleneck. […]
Read More