Sometimes a simple question gets surprisingly interesting in a distributed database: How many rows are in each shard? In YugabyteDB, the physical […]
Read More
Instantly Estimate Row Counts (Smart, Fast, and Composite-Key Aware)
Getting a row count in YugabyteDB seems simple: SELECT COUNT(*) FROM transfers; But in a distributed system, this is: ● A full-table […]
Read MoreFast Row Counts for Partition Key Columns in YSQL
Every YSQL table should have a primary key which identifies a unique row. A primary key has 2 components: The partition key […]
Read More