🟢 Update (Nov 2025): The colocation issue described in this tip has been fixed in YugabyteDB 2025.1.1.2. You can now create hash-partitioned […]
Read More
Speeding Up COUNT(*) on Partitioned Tables in YugabyteDB
When working with large partitioned tables in YugabyteDB, performance of simple aggregate queries like COUNT(*) can vary significantly depending on how the […]
Read MoreIdentify Hash Partitioned Indexes on TIMESTAMP Columns
In a distributed SQL database like YugabyteDB, the way data and indexes are partitioned across nodes has a major impact on performance. […]
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