As of YugabyteDB 2025.1, you can now use the PostgreSQL feature EXPLAIN (SETTINGS) to see which planner-related GUCs (configuration settings) were non-default […]
Read More
How to Identify Index Partitioning Method in YugabyteDB (HASH vs. RANGE)
When working with YugabyteDB, especially in large or distributed deployments, understanding how your tables and indexes are partitioned is critical for performance, […]
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 MoreFinding Unused Indexes in YugabyteDB (YSQL)
As your application evolves, it’s common to accumulate indexes that are no longer being used. These unused indexes take up storage, slow […]
Read More