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

PostgreSQL

1199 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] GammaGames@beehaw.org 2 points 2 years 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)