YugabyteDB YSQL supports PostgreSQL-style table inheritance using the INHERITS keyword—a powerful tool to streamline schema design and avoid redundancy Why Use Table […]
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 MoreResetting the YSQL Session: Understanding RESET ALL in YugabyteDB
If you’ve ever found yourself deep in a performance tuning or debugging session in YugabyteDB, experimenting with session-level configuration parameters (also known […]
Read More