Introduction to 'WITH' Queries and their Materialization
Divya Sharma is a Sr. Database Specialist SA at AWS, focusing on RDS/Aurora PostgreSQL. She has been working with AWS for over 5 years now. Her day to day includes helping enterprise customers with homogeneous and/or heterogeneous migrations to AWS RDS/Aurora PostgreSQL. She also helps customers optimize their workload on RDS/Aurora PostgreSQL, by enabling them with the best practices.
Checkout the slides
In this session I will talk about : 1. What are Common Table Expressions 2. Advantages of using them - readability, re-usablity, tree traversals etc. 3. What are Materialized CTEs - what changed from version 12+ for the planning/execution of CTEs 4. Should I use CTEs?
The talk is to explain the idea of how are CTEs planned and executed in different versions of PostgreSQL and when if you should use them or not.
- 2023 February 23 - 12:15
- 45 min
- Grand Victoria 1
- PGConf India, 2023
- Database Administration