Sometimes you have a small dimension table that is read constantly, joined frequently, and rarely updated. For example, maybe every application region […]
Read MoreDon’t Forget to Pre-Split Large Indexes
When designing for scale in YugabyteDB, we often think about pre-splitting large tables. But indexes matter too. In YugabyteDB, secondary indexes are […]
Read MoreWhen work_mem Affects Batched Nested Loop Performance
Sometimes a query plan can look right at a high level, but the distributed execution details tell the real story. In YugabyteDB, […]
Read MoreFinding Triggers That May Be Doing Hidden Work
Triggers can be easy to forget about. A query may look simple from the application side, but behind the scenes a trigger […]
Read More