CTE vs Materialized CTE vs temp table

What is a CTE?

• does it store it in memory?

Materialized view

Temp table

CREATE TEMP TABLE

is faster than creating CTEs

• why?
• is this even true?

Materialized CTE

postgresql - Are there side effects to Postgres 12's NOT MATERIALIZED directive? - Database Administrators Stack Exchange

?

---

Last update: 2023-04-24