A common tuning pattern in YugabyteDB is finding a query that looks simple, has indexes available, and still performs inconsistently. This often […]
Read More
When Generated Columns and Indexes Turn a Simple JSONB UPDATE into a Distributed Write Amplifier
The the previous tip, Update JSONB the Smart Way with jsonb_set() and the || Merge Operator, we looked at two cleaner ways […]
Read MoreWhen Index Read Latency Creeps Up, Look Beyond Compaction
A slow query is not always just a “bad query.” Sometimes the query plan looks reasonable, the index is being used, and […]
Read MoreWhy HNSW Indexes Are So Fast in YugabyteDB
Vector search gets expensive fast. Without an index, every query has to compare your search embedding against every row in the table. […]
Read More