Creating a High-Performance Index for PostgreSQL and YugabyteDB | Workshop | DSS 2024

PostgreSQL is powerful for various applications. The ability to create custom indexes is essential for optimizing database performance. YugabyteDB inherits the indexing features of PostgreSQL, and when distributed, optimizing data access becomes even more critical.

In this workshop, you will learn how to construct a high-performance index tailored to your specific use case from the ground up. We will begin with a single-column index that improves query efficiency for a single-server PostgreSQL instance. Then, we will demonstrate advanced techniques for optimizing the index further, to scale in distributed environments. We will analyze the execution plan and optimize all parts of the SQL statement, including the WHERE clause, the ORDER BY, and the SELECTed columns.