Yugabyte University

As a distributed PostgreSQL-compatible database, YugabyteDB has a ton of similarities and a few differences when compared to open-source Postgres. YugabyteDB does behave and look like Postgres in runtime which allows you to reuse most optimization techniques you've already mastered with Postgres. At the same time, YugabyteDB is a distributed database that can store your data across multiple geographies and use thousands of CPUs distributed across hundreds of nodes which requires you to consider query tuning patterns specific to distributed systems.

During this workshop, you'll learn and receive hands-on experience with techniques, concepts, and toolsets used for performance optimization and query tuning in YugabyteDB. By following simple examples, you'll start with generic SQL optimization concepts and tactics, and then do a deep dive into advanced optimization techniques specific to YugabyteDB's distributed nature.

What you’ll learn and how you can apply it:

• Tables and indexes internals, and their scan operations
• Basics of hash or range sharding for tables and indexes
• Best practices for indexing distributed data, includes covering and partial indexes
• Types of joins and when they perform the best