Скачать или смотреть Learned Indexes in PostgreSQL: Theory & Implementation, Gary Evans | FOSSASIA Summit 2025

Traditional indexing structures, such as B-trees and hash indexes, have been foundational in optimising database query performance for decades. However, recent advancements in machine learning have introduced “learned indexes,” a novel approach to data indexing that leverages statistical models to predict data locations. This method can potentially outperform traditional indexes in read-heavy workloads, especially in scenarios where data distributions are skewed or non-uniform.

In this talk, we’ll dive into the principles of learned indexes, explore how these ML-driven models aim to replace or supplement conventional indexing methods. We’ll cover the potential benefits, including lower memory footprint, reduced storage overhead, and faster lookup times for certain query types. Additionally, we’ll address the challenges and trade-offs of integrating learned indexes into PostgreSQL, where durability, adaptability, and compatibility with existing query optimisation techniques are crucial.

Attendees will come away with a comprehensive understanding of learned indexes’ potential benefits and limitations real-world PostgreSQL environments.

FOSSASIA PGDay 2025 is an event focused on the PostgreSQL database, held in conjunction with the FOSSASIA Summit in Bangkok, Thailand. This event brings together leading companies offering PostgreSQL solutions, organizations leveraging PostgreSQL in-house, and ASEAN-based businesses and government agencies exploring PostgreSQL as a scalable, reliable, and advanced database option. Learn more: http://summit.fossasia.org/pgday

Session slides: https://eventyay.com/e/4c0e0c27/sessi...

#FOSSASIA #FOSSASIASummit #opensource #FOSS #postgresql