Introduction to 'WITH' Queries and their Materialization

Presented by:

21fbbf55b2cd3cd61c40b512b5dfbd9c

Divya Sharma

from Amazon Web Services

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

Happening at the same time:

  1. Reducing PostgreSQL Costs in the Cloud
    2. Start Time:
    2023 February 23 12:15

    Room:
    Robusta + Arabica

  2. Redis vs PostgreSQL: Making the Right Choice
    3. Start Time:
    2023 February 23 12:15

    Room:
    Grand Victoria 2