Query processing is an important functionality of a database product like PostgreSQL. Given the extensible nature of PostgreSQL, advanced users may want to become familiar with the interfaces that PostgreSQL provides in order to extend the core functionality to meet specific workload needs and to leverage in-house capabilities such as hardware acceleration, distributed computing, and more.
Key takeaways:
- High-level architecture of query processing in PostgreSQL
- Detailed look at the path a SQL query takes through query processing components and the internal representations of its implementation
- Ways in which user-written C code can be used to extend the core query planner and executor
Speaker: Amit Langote, Database Architect, EDB