YugabyteDB now supports foreign key references to partitioned tables…a PostgreSQL 12+ feature that brings referential integrity to partitioned parents. This is available starting […]
Read More
Multi-Column LIST Partitioning
Multi-column partitioning can be a powerful tool for organizing data. In databases like Oracle, you can define a LIST partition on multiple […]
Read MoreColocation Gotcha: Creating Hash-Partitioned Tables with Range Partitions in YugabyteDB
🟢 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 MoreSpeeding 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 More