Introduction to 'WITH' Queries and their Materialization
Presented by:

Divya Sharma
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.
- Date:
- 2023 February 23 - 12:15
- Duration:
- 45 min
- Room:
- Grand Victoria 1
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Administration
- Difficulty:
- Hard
- Reducing PostgreSQL Costs in the Cloud
- Start Time:
- 2023 February 23 12:15
- Room:
- Robusta + Arabica
- Redis vs PostgreSQL: Making the Right Choice
- Start Time:
- 2023 February 23 12:15
- Room:
- Grand Victoria 2