this post was submitted on 08 Sep 2023
14 points (100.0% liked)

PostgreSQL

643 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago

I wonder how CTEs perform compared to subqueries. I’ve mostly replaced subqueries with CTEs because they’re waaaay easier to maintain (especially when looking at someone else’s code)