Common questions engineers search for: ● Why is my indexed query still scanning thousands of rows? ● Why does PostgreSQL / YugabyteDB […]
Read More
How to Choose the Right Column Order in an Index
Introduction Designing an efficient index is one of the most important skills for optimizing SQL queries. Many developers know that indexes improve […]
Read MoreNo More ANALYZE After CREATE INDEX in YugabyteDB 2025.2
TL;DR Starting in 2025.2.0.0 (and backported to 2025.1.3.0), YugabyteDB automatically updates pg_class.reltuples for both the base table and newly created index after […]
Read MoreUnderstanding Index State with PITR in YugabyteDB
Point-in-Time Recovery (PITR) in YugabyteDB protects databases from accidental DDL and DML by allowing recovery to a previous point within a configurable […]
Read More